% of Grand Total Issue

[gunner12]

Hi there,

I am currently trying to show % of revenue by sector by financial year (FY17, FY18, FY19, FY20 (as below).

Unfortunately, the % is calculating based on the Grand Total of all 4 years where I would like it to calculate from the total of each individual year.

Hoping someone can please point me in the right direction as to how I might go about resolving this.

 

[GraH]

Hi, you might want to show the formula behind the measure to make it easier to help you.

 

[Aditya_Shanmugham]

You might want to refer something from here, however providing the formula will help us to help you better