Still need help with pivots - Single Column Pivot

sigh !

I think I need an intervention when it comes to pivot and unpivot 

Let's start with pivot, I understand it can do some incredible grouping , but I can't even wrap my head around single pivot  


Excel Terms
I want to pivot on Field Status, So Column Becomes Status , Rows = Brands , and Record id# is the value I want to "COUNT"

EDT Terms
Set Key ?; Pivot Key = Status  ; Pivoted Value= ?

What does Pivot Keys do here?

Input
 


Output
 


Expected Output from  Entire Dataset

You need to sort and group the data first.

I will create an example for you

Please see attached working example.



 

HI,

Thanks for the example .it's clear(ish) now. Let me try 

0. Sorting is critical 
1. Pivot by itself will not do any calculations (sum/count)
2. To do this grouper is required where we employ Group by fields and actually do calculations we want
3. IN pivot , PivotKey is where we list down ALL the columns we want, if a pivot key is NOT listed that "value" will not be a part of output 
4. In example provided , I could have , not removed Record ID# using field selector , and instead used counting in Record ID#??

I am going to do a video on this, this would be helpful for me in future to remember , or for someone in my team as well

Now this is the easy Single Column Pivot  .
The wiki talks about a slightly complex pivot , can I get the example file for that (if you have)



 

In example provided , I could have , not removed Record ID# using field selector , and instead used counting in Record ID#??

>>>I think this will work as well, as you can see there are multiple ways of doing things with our software 

The wiki talks about a slightly complex pivot , can I get the example file for that (if you have)

>>. Yes we do have it in default repository 0037 Pivot Example.

PS you are not the only one who is confused about the pivot (I keep forgetting how it works)
 

Video as promised for Future Self
www.loom.com/share/4bbb2898938740eabd256...6b-8a62-2ee63c3eacc5

Do you know there is an upper limit to characters in Pivot Key for some reason ? Please remove , makes user job difficult  . See video at 4:24 to know what I am talking about