I'm trying to figure out how to calculate the percentage (=((Sum([CY 2017]) - Sum([Prev.CY 2017])) / Sum([Prev.CY 2017]))) for each row in the table accuractely. Here's a picture for reference.
As you can see, the numbers aren't accurate. Please help.
May be check if individual part of the expressions make sense
1) Sum([CY 2017])
2) Sum([Prev.CY 2017])
Can you share a screenshot with Region as dimension and the above two as expressions?