3 Replies Latest reply on Oct 25, 2016 10:33 AM by Kimber McDevitt

# is it possible to create a grand total (or subtotal) for a discrete measure?

I am creating a worksheet that has rows containing several dimensions, a discrete measure (revenue, a calculated field of items*cost) and a sideways bar chart (of items sold).  I understand how to subtotal and grand total the continuous measure used in the creation of the bar chart.  However, I can not seem to figure out how to display a grand total for the column that contains the discrete measure revenue.  When I apply the grand total to columns it only affects the continuous measure and the discrete measure is blank.  I do not want to make the revenue a continuous measure because it will be displayed as a bar chart - though if there is another way to accomplish this task, I'm open to suggestions.

Example

Item#    ItemName   Revenue   Bar (of number sold)

Item#    Item Name  Revenue   Bar (of number sold)

Thanks in advance for any suggestions!
~Kim

• ###### 1. Re: is it possible to create a grand total (or subtotal) for a discrete measure?

Hi Kim, one option would be to create another sheet that only has a total row and then put that below your current sheet in a dashboard. You would just have to remove all the dimensions from your rows shelf in the new sheet to get the totals. But there's no way to display a total value directly under a header.

1 of 1 people found this helpful
• ###### 2. Re: is it possible to create a grand total (or subtotal) for a discrete measure?

Hi Kimber,

I am not sure what your are aiming for.

Find below my approach depicted and stored in attached workbook version 9.3

1 of 1 people found this helpful
• ###### 3. Re: is it possible to create a grand total (or subtotal) for a discrete measure?

Thank you this worked but the outcome resulted in my loosing the nice printable sheet that I had in the worksheet.  Now when I print, it only prints what is on the screen including the scroll bars.  Is there a better setting to use in the dashboard so the entire sheet can be viewed and printed?

Thanks for the help!  Progress was definitely made!
~Kim