Friday, September 21, 2012

Webinar: Excel PivotTables and Slicers

AppId is over the quota
AppId is over the quota

Hmmm, noodling on this a bit, as we aren't exactly sure what you want. Here's are two potential answers from the Excel writers:

but he may be able to do what he wants by turning on Classic View, so he can drag the calculated values where he wants them. When in a PivotTable, click the Options tab. On the far left of the Ribbon is the Options button. Look for Classic layout under Display.

Sounds like he wants to duplicate entries. You can do that in the Field List by dragging the same field to the Values area, and placing it below the field that’s already there. Then you can change the calculated field by using Show Values As (you’ll see that by right-clicking), or you could use another formula in that field, I believe.


View the original article here

No comments:

Post a Comment