Tags: CUBEVALUE

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

{ 0 Comments }

By Ashish Mathur · · · 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 […]

Read More →

Customise Pivot Table reports

{ 8 Comments }

By Ashish Mathur · · · 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 […]

Read More →

Sales data modelling and interactive visualisations

{ 30 Comments }

By Ashish Mathur · · , , · Leave a comment

Visualise Sales Data of a Non-Alcoholic Beverage Company with basic columnar information such as Date of Sale, Time of Sale, Brand, Stock Keeping Unit (SKU), State, City, Quantity sold, Unit Price and Salesman Code.  In this sales dataset, each line item represents one visit for one SKU.  If nothing is sold in a certain visit, then the SKU […]

Read More →

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

{ 31 Comments }

By Ashish Mathur · · , , · 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 […]

Read More →