Cumulative bar graph/nested IF
Hi, I'm tryign to produce a cumulative bar graph showing cumulative months along the X axis & value on the Y axis, i can create the below which provides total value by month: If([Month]="01. Jan", ...
Forum Discussion
So "IF" and "Case" statements only return one value. The first true value in the sequence.
If you want a cumulative function like this. I'd recommend that you set up a 'parent summary' table to accomplish this.
If you set up a "Months" table, and "Years" table, you should be able to automatically roll up all the values for YTD and sequenced data.
If you want a cumulative function like this. I'd recommend that you set up a 'parent summary' table to accomplish this.
If you set up a "Months" table, and "Years" table, you should be able to automatically roll up all the values for YTD and sequenced data.