Hi All,
This is related to Pivot table.
How to achieve the Total count% and TotalSale % per Dim Prod Cat grouping ex :Cloth .I tried default (rows and column in presentation)Total but its doing adding of rows values .Note that we have a dim Product -1 to 3 so any measure added get added a column under these 3 - product but i need one Total Count% and one TotalSale%.
Really appreciate for the suggestion and solutions.
| | | | | Product1 | Product1 | Product2 | Product2 | Product3 | Product3 | | |
| Dim ProdCat | Dim geography | Dim class | Dim Weight(kg) | count | Sale | count | Sale | count | Sale | Total count% | TotalSale % |
| Cloth | USA | Class1 | 0.5 | 2 | 90 | 1 | 300 | 2 | 300 | 2+1+2/2+1+2+3+2+3 | 90+300+300/90+300+300+100+200+400 |
| Cloth | India | Class2 | 0.5 | 3 | 100 | 2 | 200 | 3 | 400 | 3+2+3/2+1+2+3+2+3 | 100+200+400/90+300+300+100+200+400 |
| furniture | Africa | Class3 | 20 | 4 | 200 | 4 | 500 | 6 | 250 | 4+4+6/4+4+6+5+5+4 | 200+500+250/200+500+250+300+700+150 |
| furniture | Austria | Class4 | 1 | 5 | 300 | 5 | 700 | 4 | 150 | 5+5+4/4+4+6+5+5+4 | 300+700+150/200+500+250+300+700+150 |
