PowerPivot Columns Question

[cr731]

I have a PowerPivot table that is summarizing an aging metric and wondering what the best way to accomplish this is: I want my columns to show an aging bucket (0 Days, 1-2 Days, 3-5 Days, etc.) and then a column showing % on Time (0 Days / Total of all buckets).

What is the best way to show each bucket with the count and then the % on Time? The "Buckets" are a column in my table, so to start I drag that field into Columns, and then I have a calculated measure with a simple row count. I then have my % on Time as a calculated field - how do I bring the % on Time into the table but not have it show up under each bucket?

Currently:

Currently:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]0 Days[/TD]
[TD]0 Days[/TD]
[TD]1-2 days[/TD]
[TD]1-2 Days[/TD]
[TD]3-5 Days[/TD]
[TD]3-5 Days[/TD]
[TD]6-10 Days[/TD]
[TD]6-10 Days[/TD]
[/TR]
[TR]
[TD]Row Count[/TD]
[TD]% on Time[/TD]
[TD]Row Count[/TD]
[TD]% on Time[/TD]
[TD]Row Count[/TD]
[TD]% on Time[/TD]
[TD]Row Count[/TD]
[TD]% on Time[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Desired

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]0 Days[/TD]
[TD]1-2 days[/TD]
[TD]3-5 Days[/TD]
[TD]6-10 Days[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Row Count[/TD]
[TD]Row Count[/TD]
[TD]Row Count[/TD]
[TD]Row Count[/TD]
[TD]% on Time[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I'd prefer to not have to create a calculated measure for each individual bucket but is that the only way?

 

[RoryA]

You should be able to create a Set since your pivot is an OLAP pivot, and just hide the % columns for the individual items.