WTD, MTD Analysis

[girish_talele]

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.

[ecolomer · Accepted solution]

Is this you need?

[girish_talele]

Dear Enrique Colomer,

Yes, this is what I needed... amazing & perfect solution .

Thank you very much.

Regards,

Girish.

[ecolomer]

You are welcome

Saludos,

Enrique Colomer

[sunny_talwar]

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

[ecolomer]

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

[sunny_talwar]

That makes perfect sense

I just wanted to provide a set analysis based solution to the problem.