How to show actual value in pivot table rather than counts or sum

[srehman]

In my case i want to show ABC class in months not any number sum or counts.

Please share your ideas.

Thanks in advance

 

[mrshl9898]

Could use a Pivot for SKU, another for MM/YY to get your headings, and arrange them next to each other. Then a formula to fill in the results.

A single Pivot won't accomplish what you want.

 

[sandy666]

add your source table to DataModel then create measure: ABCClass:=CONCATENATEX(Table1,[ABC Class],", ")
where Table1 is a name of the table in DataModel and then create Pivot Table

ABCClass	MM/YY
SKU	April-2020	December-2019	February-2020	January-2020	March-2020	November-2019	October-2019	September-2019
10016853	AA	AA	AA	AA	AA	AA	AA	AA
10028493	AA	AA	AA	AA	AA	AA	AA
10029433	AA	AA	AA	AA	AA	AA	AA

 

[srehman]

Hi Sandy i am following your instructions but my calculated field not enable how can i do measures.

Please check in attached snapshot

 

[sandy666]

add your source table to DataModel then create measure: ABCClass:=CONCATENATEX(Table1,[ABC Class],", ")

I didn't say Calculated Field

 

[srehman]

how can i go , where is this Measure

 

[srehman]

you can see formula measure is greyed out. check my snapshot in last msg

 

[sandy666]

Power Pivot - Measures - New Measure ...

Create a Measure in Power Pivot - Microsoft Support

Measures (also known as calculated fields) are one of the most powerful features in Power Pivot.

support.microsoft.com

you can see formula measure is greyed out. check my snapshot in last msg

you didn't read my posts: I didn't say Calculated Field, Calculated Filed is not Measure

 

[srehman]

Thanks for your help i am bothering you again & again, I am nearly there, In concatenate formula after Table [ do i need to type ABC Class it is not coming by pressing tab, even when i typed its giving me formula error as per my understanding this is filed name it should come by itself by pressing tab.

Please check

 

[srehman]

i tried as per your formula getting error , formula invalid