YTD report in pivot table allowed?

[surajap123]

Hi All,

I am building YTD in a pivot table. I have 4 dimensions and two expressions. First expression to get current YTD value and other expression is to get previous YTD values.

My first expession ie current YTD is giving right sales result, but previous YTD gives 0.00 as value in every row.

There is no issue with the expession for Previous YTD.

=sum({<Status = {'Cancelled'},CalendarYear={'$(vPriorYear)'},Date={'<=$(vPriorYearDate)'}>}sales)

All the 3 fields Status, Date, and Sales are in the same table(aggregated table in the script)

I wanted to know, is pivot table NOT be used to show YTD for current and previous YTD in each column across set of dimensions?

Where could be the issue, that i need to look at?

[maxgro]

remove the label from your expression and use the mouse (over) to see your expression

example, my expression is

=sum({<y={$(vPriorYear)},d={"<=$(vPriorDate)"}>} Expression1)

usually it helps to debug set analysis

[surajap123]

Hi Massimo,

Actually there was no issue. Infact there was no data for the dimensions during previous year, so i was getting 0.00.

Thanks for your response..