7 Replies Latest reply: Nov 2, 2017 11:51 AM by Sunny Talwar RSS

    Lock dimensions from filter selection

    Sujoy Das

      I have created one pivot table and one pivot chart. Both have two same dimensions(Zone,Date)  but the table has one expression(Sum of Sales) where as the chart contains three expressions (Sum of Sales, 1st Quartile of Sales and 2nd Quartile of Sales) . Hence, In  chart we need to select Zone to analyse the data date wise. But, when I am selecting a Zone its showing the graph properly but the Pivot table is showing the data only for the selected zone. I want to show the data for all the zones in the pivot table i.e. Zone selection (filer) will not impact the table but Graph will show the data for the selected zone . Can any one help on this please.