Forum Discussion

rauldip22's avatar
rauldip22
Frequent Visitor
7 years ago
Solved

How to summarize and Transpose headers for rows?

Hi to everybody!   I have this problem:   I have this data:   Country Sell Cost Argentina 3455 675 USA 3321 346 Australia 6754 720 Argentina 4332 786 Canada 7753 9...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    Hi rauldip22 - you want to use a matrix visual instead of trying to recreate a table.  Country would be the columns, and your different measures for Sell, Cost, and Difference would be the values.  You'll also need to turn on "Show on Rows" under "Values" in the format painter.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Hope this helps

    David

     

     

     

     

     

     

rauldip22's avatar
rauldip22
Frequent Visitor
7 years ago

Thanks!! It worked!

 

I have another question, there is a way to add aditional columns into the same Matrix? For example, If I Have "days" column like that:

 

CountryCategorySellsCost
ArgentinaA3455675
USAA3321346
AustraliaC6754720
ArgentinaB4332786
CanadaA7753986
AustraliaC5522432
ArgentinaB9856936
USAA5436876
SpainA3876946
SpainB7634345
USAC9468234
ArgentinaC7643745

 

I would like to add the Category column to the matrix and obtain something like this:

 ArgentinaAustraliaCanadáSpainUSAABC
Sells252861227677531151018225238412182229387
Costs3142115298612911456382929672131
Difference221441112467671021916769200121885527256

 

There is a way to develop this?

dedelman_clng's avatar
dedelman_clng
Community Champion
7 years ago

I don't think that is possible in a single matrix.  You could rig up something where there are two matrix visuals and the one with Country overlaps the one with Category, but as soon as you get more countries or applied a slicer the whole thing would become a mess.