Tags: CUBESET

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

{ 0 Comments }

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 →

Show Slicer selection on a Graph

{ 7 Comments }

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

Read More →