Forum Discussion
Hiding VALUE items in SUM columns
I'll generate some sample data if necessary, though it would take some time to sanitize.
However, to answer your question - When the visualization is completely expanded, the "detail" or base row which gets summarized up level to level should show the date (no summarization in category rows), the item and item description (no summarization in category rows) and then the sales numbers which should have summarizations in the category rows. It shoud look like this (an example of the app in HCL (formerly IBM, formerly Lotus) Notes which we're migrating away from.
As you can see in the image. There's nothing in the categorization columns - the item and date only show in the "detail" section of the column. BTW Report Builder can do this when building reports for SSRS.