Set Expression

[baarathi]

Hi I have attached a file in which i need to calculate the percentage for Revenue % = (sum(Amount) - sum(Adjustment)) / Total (sum(Amount) - sum(Adjustment))  for particular month-year.

[baarathi]

Ya In the sample Data Which I have sent there is no data for Top and Low in same month-year. But there are cases where i have both top and low in same month-year.

[OmarBenSalem]

Try this:

as column: Year

as Line: PType

as measure

(Sum(Amount)-sum(Adjustment)) / (sum(total <Year> Amount)-sum(total <Year> Adjustment))

[baarathi]

Still I'm not getting the answer correctly.