Inline table dimension and totals in pivot table

[Anonymous]

Hi all,

I have a created a inline dimension - Month to create the below pivot table. This is YTD table for sales and we have a separate calendar and its Mar in that calendar.

Dimenion - Month

Expression for Actuals: if( Month = Jan , sum ({<Crtd_Month = {'Jan'}>]Sales),....etc till if(Month = Dec, sum ({<Crtd_Month = {Dec}>]Sales)

Expression for Plan:if( Month = Jan , sum ({<Tar_Month = {'Jan'}>]Sales),....etc till if(Month = Dec, sum ({<Tar_Month = {Dec}>]Sales)

We have Month dimension as a filter too.

Is there any way we can show the totals in this table? And the total should show up even when we click on the Month filter . for eg. if we click on Jan and Feb month filter the table has to show Jan, Feb and Total columns.

    Now:

Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Actuals	1000	2330	230	0	0	0	0	0	0	0	0	0
Plan	700	2000	1000	0	0	0	0	0	0	0	0	0

Expected:

Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
Actuals	1000	2330	230	0	0	0	0	0	0	0	0	0	3560
Plan	700	2000	1000	0	0	0	0	0	0	0	0	0	3700

Its kind of urgent requirement. Any help would be much appreciated. Kindly let me know if the requirement is unclear

Thanks,

Anupama Jagan

[Anil_Babu_Samineni]

Will you able to provide sample? I am sure this is doable

[Anonymous]

Oh I have all the files in client network and cannot be shared over here. is it okay if I provide you some sample data alone?