The caption sounds ocnfusing, but i couldn't come up with a better one:
Problem is, if you have hirarchical data like Date.Calendar, you have "sub" values that can be collapsed and expanded
Problem is, when you have more headers, that sit below therese hirarchies, they will be collapsed too.
In this example, "Category" sits below there.
See how the Category is not visible, because Icollapsed the whole year 2010.
Compare that to 2011 where all categories are visible, because its fully expanded.
The feature I am requesting here is to still be able to show columns for each category and aggregated values, even though the year is collapsed.
I know this would be acchieved by moving category on top of the headers, but this also changes orders of the columns.
Our old windows forms pivot grid had this kind of functionality.
MSPaint to the rescue, this is how I imagine it (ignore the numbers, they do not make sense)
Hello Martin,
let me rephrase this requirement, maybe its more clear:
Right now, lets say you can collapse/expand like this:
Year => Quarter => Month => Gender
The only way, the control displays data based on gender is, if you fully expand its hierarchy.
There is no way you can show the "yearly" gender values, you allways have to break down to month level before you can see gender values.
So it would be nice, if you could collapse Year (so Quarter, Month is hidden) but still expand gender. So you see the total values of the whole year for male and female.
Thats what i tried to express in the screenshot i edited with paint.
RadarSofts Pivot Control can do this (im not sutre the screenshot will help you though).
This is a cube based on our testdata, you can see that "GJ 2008" (business year 2008) is collapsed, but its sub categories are expanded and show their yearly values.
GJ 2007 is expanded to semesters, but sub categories are collapsed.
