CUBEMEMBER | Ashish Mathur's Blog

Sort individual columns of a Pivot Table based on a slicer selection

{ 0 Comments }

By Ashish Mathur · November 2, 2016 · CUBE FORMULAS · Leave a comment

Here is a simple four column dataset Week Team User Codes 1009-1016 Default-LossMit FAST INTL\KOrdillano ATPD/5 1009-1016 Default-LossMit FAST INTL\KOrdillano ATWI/116 1009-1016 Default-LossMit FAST INTL\KOrdillano ATWI/3B 1009-1016 Default-LossMit FAST INTL\ADulnuan ATWI/116 1009-1016 Direct – HSD INTL\JCustodioii S/2 1009-1016 Default-LossMit FAST INTL\abacud ATWI/116 1009-1016 Default-LossMit FAST INTL\SCaparon ATWI/116 1009-1016 Default-LossMit FAST INTL\ADulnuan ATWI/116 1009-1016 Default-LossMit FAST […]

Customise Pivot Table reports

{ 8 Comments }

By Ashish Mathur · July 20, 2014 · POWERPIVOT · Leave a comment

Assume that someone has created a Pivot Table using the PowerPivot tool. Now one may want to customize the Pivot Table even further by: 1. Shuffling rows in the Pivot Table; and 2. Recomputing subtotals and Grand Totals after reshuffling rows A Pivot Table created via the PowerPivot tool can be converted into a normal range […]

Display data from the Grand Total column of a Pivot Table on a Stacked Pivot Chart

{ 31 Comments }

By Ashish Mathur · June 28, 2014 · GRAPHS AND CHARTS, PIVOT TABLES, POWERPIVOT · Leave a comment

Assume a simple Sales dataset from which a Pivot Table has been created. The Pivot Table has been sliced by two columns of the dataset. To represent data graphically, a Stacked Pivot Chart has been created from this Pivot Table and the chart is placed on a separate worksheet (of the same workbook). The Stacked […]

Tags: CUBEMEMBER