Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table which has month as a column dimension.
'Month' is also a field in the document so when I choose September, for example, the table has only one column headed 'September'.
How could I make the pivot table to show columns for all months from january to the selected month?
Thanks
Using set analysis could solve your issue. To help you with that you'll need to give us your expression & dimension field.
Another question.. do you only load month or is there also a year field? This might affect the expression.
in your expressions you need to ignore the month selection, like sum({<Month=>} Sales), this expression will return the sum sales ignoring your month selection, now from this expression you can create what you want, if it is incremental or not.
Malek, it is a requirement that all months up to the selected month should be displayed. Ignoring the month selection is not going to work.