Home Forums Power Pivot Recursive Frequency Matrix

Tagged: 

This topic contains 0 replies, has 1 voice, and was last updated by  volfied 2 months, 1 week ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #8211

    volfied
    Participant
    • Started: 7
    • Replies: 14
    • Total: 21

    How would you go about creating a frequency matrix from a single column, matched on a unique identifier?

    Data                                  Result

    ID  Value             D  C  B  A
    1   A              A  0  2  1  2
    1   C              B  1  1  2  1
    2   A              C  0  3  1  2
    2   B              D  1  0  1  0
    2   C
    3   C
    4   D
    4   B

    I’m hitting a wall on this. It would need a duplicate of the Value column, I gather, but I can’t figure out how to get the context of the measure to come out right.

    Thanks in advance for any help you can offer.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.