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?