How to calculate YOY market share

[abc_18]

Hello,

• I have to show market share trend which is based on fiscal year.

I am using below formula but for trend it's bifurcating max year value, not giving correct trend for all financial year

Sum({<fyear>}sales)

/

Sum( {<fyear>}total sales)

[Kashyap_R]

Hi

try

Sum({<fyear=max(fyear)>}sales)

/

Sum( total sales)

or

Sum({<fyear=max(fyear)>}sales)

/

Sum( Allsales)

Hope this helps

Thanks