-
1. Re: Perform table calculation on last column only
Tracy RodgersMar 8, 2012 4:27 PM (in response to Jeff Johnson)
Hi Jeff,
Currently, there is no way to hide those blank columns without, as you noted, hiding the years in all of the Measure Names columns. This would be a good one for Ideas in the Community.
My best recommendation for this would to separate them out into three sheets and place them on a dashboard together.
Hope this helps!
-Tracy
-
2. Re: Perform table calculation on last column only
Joe Mako Mar 8, 2012 9:15 PM (in response to Jeff Johnson)I see this as a data structure situation, and you have a few options, here are the first ones I think of to keep it as a single worksheet:
- restructure your data source with an unpivot
- restructure your data source by duplicating your data
- create a separate calc field for each column you want to display (in this case 7)
The first and second are very similar, and would take your data source size from 80K records to 240K records. The third option is a little more hassle to maintain, but does not duplicate your data.
attached is an example of the third option.