Solved: Market Share % - Pivot Table - Qlik Community

Purushothaman · ‎2022-05-10

Hello Experts,

Please help me with the Market share % requirement. I have attached the requirement and data model qvf for your reference.

I am struggling to fix this for past couple of days. Anyone Please help!!

Thank you!!

MayilVahanan · ‎2022-05-10

HI

Do u want something like below?

=If(L2 = 'TOTAL', Sum(SalesUSD)/ Sum(Total SalesUSD), Sum(SalesUSD)/ Sum(Total<L1> SalesUSD))

PFA

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

MayilVahanan · ‎2022-05-10

HI

Do u want something like below?

=If(L2 = 'TOTAL', Sum(SalesUSD)/ Sum(Total SalesUSD), Sum(SalesUSD)/ Sum(Total<L1> SalesUSD))

PFA

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Purushothaman · ‎2022-05-11

Thanks a lot once again for helping me. Greatly appreciated!!!

Market Share % - Pivot Table