Forum Discussion
Helper VMatrix different granularities
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?
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.
1 Reply
- Jihwan_Kim
Super User
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.