Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Is there data for Total-workdays where Year = 2013 and Type = Current?
can you attach your app?
Hi Christopher,
Data is available for year = 2013 and Type = Current, but data is not available for all the branches.