What would be the best solution to accomplish the following?
The report would look as follows
Year 1 Total Year 2
Month 1 Month 2
Total items 25 12 5
Item type 1 8 9 4
Item type 2 7 2 3
Item type 3 9 5 1
When you click on the Year 1 totals, the detail months should expand
and shift everything to the right.
Just like in a table, you can hide the detail rows of a table, I would
like to hide/unhide the detail columns of a Matrix. However, when I go
to toggle the visibility of the column like I toggle the visibility of
a row in a table, it only hides the column header (obviously because
it's only toggling the visibility of the textbox itself instead of the
entire column). Is there any way to toggle the visibility of a column
in the same manner you do a row in table?
This could also be accomplished with a Table, utilizing static columns,
but that is not ideal.
In Excel, all that needs to be done is to is to group the headers, and
use the new group field to display the PivotTable headers.
Is there an easier/better way to accomplish what I'm trying to do?After hours of searching, shortly after I wrote this, I found the
answer here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_0zvx.asp
So nevermind.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment