Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
In a production analysis we are building an analysis for WTD & MTD, wherein we have data as shown in below table 1.
The requirement is as shown in second table.
We could achieve WTD & MTD Values for individual Segment (i.e. Qty, Value, Cost), but struggling to achieve requirement.
Please suggest on the same.
Regards,
Girish.
Is this you need?
Is this you need?
Dear Enrique Colomer,
Yes, this is what I needed... amazing & perfect solution .
Thank you very much.
Regards,
Girish.
You are welcome
Saludos,
Enrique Colomer
Although this post has already been closed and resolved, but I thought I would provide an idea for a slight improvement. Currently the expressions from ecolomer are using if statements, but I think we can do the same using set analysis. Set analysis is better here because it is going to give better performance compared to the if statement because set analysis is evaluated once per chart, where as if is evaluated on each dimension. In this particular case, I see no reason for evaluation on each row and therefore I feel that set analysis might be a better option
Chart3 is using if statement and Chart 4 is using set analysis.
HTH
Best,
Sunny
P.S. I used qvw in Enrique's response and made additions in there
Very good solution, stalwar1
Good solution, but I did not care formulas and used which already had, and gave a solution to how to present that was his concern.
BR
Enrique
That makes perfect sense
I just wanted to provide a set analysis based solution to the problem.