1 Reply Latest reply: Apr 5, 2017 11:20 AM by Sunny Talwar RSS

    One aggregated row when no filter is selected.

    Shiva Nagesh Bodepudi

      Hi All,


      Build a pivot table samething like below

                     Month Month1   Month2  Total


      A                        10               20          30

      B                         20               30          50

      C                          30               40          70

      is when i have no selection on filter "dimension".

      and  shows respective A, B, C values when a value is selected in filter.


      Here when no filter is selected,

      I want My table look like

                     Month Month1   Month2  Total


      ALL                        60               90          160


      Please help.