'=<' in a Pivot table dimension

[#1]

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

[simondachstr]

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.

[maleksafa]

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.

[simondachstr]

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.