Partial Sum issue in pivot table

[udaya_kumar]

Hi,

I have data with country, branches and total working days data for 2013 and 2014 year.

Data is available for all the branches in 2014, but not all branches has data in 2013 year.

I have created a pivot table with country, branches as dimension and

one expression for 2014 and another expression for 2013.

The "Show Partial Sum" functionality is working properly for 2014 year expression, but 2013 expression

the total value is showing null.

Expression used for 2014 is

num(only({<Year={$(=max({1}Year))},Type={'Current'}>}Total_workdays),'#,###.##')

for 2013

num(only({<Year={$(=max({1}Year)-1)},Type={'Current'}>}Total_workdays),'#,###.##')

How to solve this issue?

[chrislofthouse]

Is there data for Total-workdays where Year = 2013 and Type = Current?

can you attach your app?

[udaya_kumar]

Hi Christopher,

Data is available for year = 2013 and Type = Current, but data is not available for all the branches.