CUBERANKEDMEMBER | 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 […]

Sales data modelling and interactive visualisations

{ 30 Comments }

By Ashish Mathur · July 5, 2014 · POWER BI, POWER VIEW, POWERPIVOT · 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 […]

Show Slicer selection on a Graph

{ 7 Comments }

By Ashish Mathur · June 26, 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 pictorially, a Pivot Chart has been created from this Pivot Table and the chart is placed on a separate worksheet (of the same workbook). Now let’s say, a […]

Tags: CUBERANKEDMEMBER