Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a requirement to show the share of a product in its market (There are multiple markets).
Attached is a excel sheet showing what I want to achieve and qvw with calculation I'm using.
This works only when a product is selected.
Please help me with this.
Hi,
Check on this file. This is based on your excel attached file.
Regards,
Janzen
Thanks Janzen for a speedy reply.
But this works only when Product is not selected.
Hi,
I have updated the previous file.
Regards,
Janzen
Here is your solution.
Regards,
Kaushik Solanki
Works fine.
Is there a way to make this independent of month selection.
I tried adding Month=, in the set expression. But does not seem to affect it.
Hi,
What do you mean by independent of month selection? Does my solution fix your problem? If it does, kindly mark as correct for future references.
Regards,
Janzen
Hi,
What I mean is, even if I select a month, it should show me values for all 3 months in the chart.
Is this possible?
Thanks in advance.
Found the solution on this thread: