Skip to Content
0

Average function in Calculation Context

Jul 14, 2017 at 07:44 PM

56

avatar image

Hi,

I am struggling with solution for past few days. I have a measure variable, company name and region in the report. I want to look at average of the measure at region wise(for all the companies). But the average value is not correct. When I add Company name to the table I get the correct value. But the requirement is I don't want to see the company name in the table.

I cannot hide the company name dimension, that would give multiple lines instead of a single average row.

I used Average([Measure] foreach [Company Name]) but it did not work. I tried forall,foreach, in with multiple combinations but to no success. Can anyone help me with the resolution?

P.S: The Region is a grouping variable

Thank you,
Shravya

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Jul 15, 2017 at 12:29 PM
0

instead of measure variable create dimension variable and try

Share
10 |10000 characters needed characters left characters exceeded