Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I shared a sample data in attachments
As example data
in Overview pivot have Large Claim
and High claimant
in year 2019 (report Year) we have Large Claim = 777,594 it is true because 777,594 > 700,000(Large Claim)
but High Claimant it is wrong because in 2019 we have 777,594 and in 2018(prior year) we have 1,633,221 but in High Claimant Overview pivot we have 11,483 it is wrong must show 1,633,221 on displays.
Please help.
You want 1,633,221 for 2017, right? because I see 11,483 as Prior Year when 2018 is selected