Forum Discussion
How to group/classify measures segmentation
I have looked at a couple of options to accomplish what I am looking for but not sure I follow the other solutions. Below is the layout I am looking for in my matrix. All I have is a single transac...
Anonymous
Not very clear with text description, can you provide a sample table and an expected output matrix.
Regards
Paul
The data really isn't the issue. My measures are Sales_MTD, Sales_YTD, GrossProfit$_Daily, GrossProfit%_Monthly etc
To get the Pivot I posted I need to label Sales calculations as sales, Gross Profit as GP, and Gross Profit % as GP%. The segmentation patterns seem to work with ranges.
| Account | Division | Branch | Department | Account Type | Date | Amount |
| 7800 | MWC | GAD | Parts | Sales | 6/1/2020 | $1,000.00 |
| 5600 | MWC | GAD | Parts | COGS | 6/1/2020 | $500.00 |
| 7800 | MWC | GAD | Service | Sales | 7/1/2020 | $1,000.00 |
| 5600 | MWC | GAD | Service | COGS | 7/1/2020 | $500.00 |
| 7802 | MWC | GAD | NEW | Sales | 5/1/2020 | $55,000.00 |
| 7802 | MWC | GAD | NEW | Sales | 5/1/2019 | $12,000.00 |
| 5601 | MWC | GAD | USED | Cogs | 5/1/2019 | $35,000.00 |
| 5601 | MWC | GAD | USED | Cogs | 7/1/2020 | $23,000.00 |