Set Analysis Required

[varunvarma]

Dear All,

Greetings!!!!

Please support to write set analysis in the expression. Please find the attached excel. I explained requirement in OUTPUT tab. I need to create a pivot table with two dimensions (MODEL, DIM) and one expression. Please support to create same. Thanks in advance.

[anbu1984 · Accepted solution]

=COUNT(If(DOR = (DIM-1),VIN)

[#3]

Hi,

Please have a look this one.

Thanks

[alexandros17]

Here it is

[#5]

Hi Varun,

Create a pivot chart with model and dim as dimension.

After creating chart, drag dim dimension to top of pivot chart.

PFA, it might help you.

Warm Regards,

Joshmi

[robert_mika]

Chart-->Pivot table

Expression:

SUM(IF(DOR=DIM-1,1))

[varunvarma]

Thank you Anbu.

[varunvarma]

Thank you all.