Matrix different granularities

[CarlsBerg999]

Hi,

Some of my figures are budgeted on a montly basis and some on a yearly basis. If i put categories to rows and months to columns, i the yearly figures show the same value in all monthly columns. So for example february is 1meur, march is 1meur and total is 1meur. This is incorrect. Is it possible to show a value only on the "total" level?

[Jihwan_Kim · Accepted solution]

Hi, @CarlsBerg999 

Please correct me if I wrongly understood your question.

Can you try something like below?

Yourbudgetmeasure 2 = if ( isfiltered(yourmonthcolumn), blank(), yourbudgetmeasure 1)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help the other members find it more quickly.