1 Reply Latest reply on Dec 1, 2016 6:39 AM by Jonathan Drummey

    Grand Total and Navigation Issues

    Sri K

      Hi Friends,


      I am facing an issue with Grand total.


      I have created two Grid views one is summary dashboard and another one is Detailed dashboard.


      In summary dashboard i have added grand totals for column and rows and given navigation to the detailed dashboard.


      Now the problem is when i click on grand total in summary dashboard it is showing all values in detailed dashboard.



      In the above sheet is the grand totals. if i click on first row( value 45), i am getting 2012 records in the detailed view.


      I am attaching the twbx file here.


      More appreciate for your help.


      Thank you,


        • 1. Re: Grand Total and Navigation Issues
          Jonathan Drummey

          Filter Actions only 1/2 way work from Grand Totals and Subtotals. If the Filter Action is changing focus (like to another dashboard) then that action is taken, however the Filter Action doesn't actually filter anything. This is unfortunately a "feature" of Grand Totals and Subtotals.


          There are at least three workarounds to this:


          1) Teach your users to click on the headings instead of the Grand Totals. For example if I click on Bookcases instead of the #45 then I see all 45 rows for bookcases in Dashboard 2.


          2) Do a self-union of the data source and build your own custom grand totals as described in http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-3/, then with the BYO grand totals you'd be able to use a Filter Action since they would be regular marks.


          3) If the number of values of the dimensions on X and Y (months and product sub-categories in this case) isn't so large that the view would need scroll bars then you could make the grand totals as separate worksheets on a dashboard and then you'd be able to use Filter Actions.