2 Replies Latest reply on Aug 4, 2017 3:28 PM by Yuriy Fal

    Multiple Crosstab Footer Rows

    Todd Moses

      I have a crosstab of page views by category.


      I want to add two rows beneath this.  One for "total" page views, and one for "average" page views.


      Do I have to do this with three separate worksheets lined up on a dashboard or is there a better way to do this?  Could it be done with a custom SQL query?


      Thank you.


        • 1. Re: Multiple Crosstab Footer Rows
          Patrick A Van Der Hyde

          Hello Todd,


          The total is easy and is just done with the Analysis menu item - Totals -> Show Column Grand Totals


          The average is trickier.  What is the average of?  is it the avg by each category or the avg of each page or ??   Designing the average value should be done on another page and then added to a dashboard with the crosstab view.  That's the fastest and easiest way to maintain. 



          • 2. Re: Multiple Crosstab Footer Rows
            Yuriy Fal

            Hi Todd,


            There may be cases when it is possible

            to have a single view cross-tab layout

            with two distinct Custom (Grand) Totals

            using a (self)UNIONed datasource table,

            a Custom Total aggregate calculation

            and a trick with hiding some value(s)

            of a [Table Name] blue pill on Rows.


            Please find the attached.

            Hope it could be of some help.