How to write different formulae for each cell?

[Shubham_Deshmukh]

	LY	LY LM	YTD	YTD LM
A	*
B
C

* = Formulae

I have such situation, in which neither first row nor first column is dimension.

We have to manually write formula for 1 row 1 column , 2 row 1 column , ......... matrix like this.

Please help.

[Anil_Babu_Samineni]

This?

If(Match(FieldName, 'LY') and Match(FieldName1, 'A'), Formulae,

If(Match(FieldName, 'LY') and Match(FieldName1, 'B'), Formulae, ....))

[neha_shirsath]

You are taking table only?

Because here, if you write code for particular dimension field like A,B,C then if field value increases then that will become issue, rather than you can use text object

[Shubham_Deshmukh]

A,B,C and LY, YTD LY etc are not the feilds.We will have to write it manually.

[shraddha_g · Accepted solution]

You can try as below:

Dimension : Valuelist('A','B','C')

Measure 1 - LY

pick(Wildmatch(Valuelist('A','B','C'),'A','B','C'),

Expression1 for A,

Expression1 for B,

Expression1 for C

)

Measure 2 - LY LM

pick(Wildmatch(Valuelist('A','B','C'),'A','B','C'),

Expression2 for A,

Expression2 for B,

Expression2 for C

)

Measure 3 - YTD

pick(Wildmatch(Valuelist('A','B','C'),'A','B','C'),

Expression3 for A,

Expression3 for B,

Expression3 for C

)

Measure 4 - YTD LM

pick(Wildmatch(Valuelist('A','B','C'),'A','B','C'),

Expression4 for A,

Expression4 for B,

Expression4 for C

)

[Anil_Babu_Samineni]

Yes, Those are not the fields but we can achieve the same

[Shubham_Deshmukh]

Thank you so so much Shraddha.Its working.

Regards,

Shubham

[Shubham_Deshmukh]

A,B,c,d,e,g will be my string only

Now I have such Pivot table structure and same situation as before.

It worked in Straight table.

How to do it in PIVOT Table?

[shraddha_g]

Do you mean to say you will be having 4 different expressions for these pairs?

[Shubham_Deshmukh]

Ya,It is same as before but 4 valuelist variables will have one common name