question

cheutho avatar image
cheutho asked

How to create a cube that behaves differently across rows vs columns

I have a table of user counts by company. I have a cube with company and calendar dimensions. I would like to be able to create a measure that would allow me to have the Max value for each company for the time period, while still getting a grand total of the user accounts for all companies. I have found that using Max(userCount) as the measure value gives me the Max values by company, but won't total across the date period, whereas Sum(userCount) will total across both company and date period. Is there a way to do this?
ssasmdxcube
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.