Help on Pivot table

[agni_gold]

Hi Friends ,

i need one table like below ,

which not effect year selection .

[Anonymous]

Use set analysis in your expression to ignore selections in year

Something like

sum({<Year=>}Values

[agni_gold]

but for current year 2017 , 3 expression should come and for remaining year only one expression i.e FY should come

[Sergey_Shuklin]

Hello, Agnivesh!

Please, look at the attachement:

[agni_gold]

thanks for your help , but as i mentioned in my screenshot KPI should come same like that current year is 2017 then 3 columns YTD YTG and FY come below 2017 and for further years only FY expression should come below

[agni_gold]

YTD should not be dimension , YTD YTG and FY should me expression

[agni_gold]

but in some case my existing value got zero , then it will also get suppressed.

How i will handle this ?