Power pivot not along me to dissect data columns - HELP!

[FlandersFlannigan]

Hello all,

I've been working on this for.... way too long and I still haven't found a good solution. It seems so simple too, Idk know why excel doesn't have a function for this. All I'm trying to do is create a pivot report that I can toggle between two sets of data (via a slicer). In the attached workbook, under the All Data tab, I want to have a slicer that will either show RAW DATA or the WEIGHTED SCORE. Update- since I can't attach... RAW DATA and WEIGHTED SCORE are columns... This would work if it would allow me to group columns together and then use a slicer to toggle between them.

For example, say I just want to look up the Weighted Score Audit score, then I can click on a slicer and all my pivot tables will show weighted score and the same for Raw Data Audit Score.

I've tried coming up with <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> solutions, and the best one I have can be seen under the Dashboard tab, but I don't like this one, because it does not automatically update when the source pivot tables change... I hope I explained this well enough.

Any help would be GREATLY appreciated.

Oh... I can't attach anything?? Why can't i attach anything?

 

[GDRIII]

I think this might get you going in the right direction...Disconnected Slicers + SWITCH

Dynamic TopN Reports Using PowerPivot V2! « PowerPivotPro