1 of 1 people found this helpful
Best way to do that is to create a second sheet that displays the extra stuff, and position it next to the actual data sheet on your dashboard.
I agree with Joe; using dashboard positioning is an extremely useful workaround for these kinds of issues.
You might also be able to use some clever calculations to do this in one sheet using subtotals and grand totals, but I think that might be more effort than it's worth.
Thank you Joe and David for your replies. The only issue I potentially see with a duplicate sheet is that if I position this and just show the average column, it may go out of synch to the first sheet due to vertical scroll bars.
May just have to look at some form of calculated field/subtotalling as mentioned.
Hi Paolo - there is no reason for duplicate sheet to be out of sync as far as it has all the same filters applied.
Just right click on the tab for your sheet and select Duplicate
from here you just need to take out the date field and change the measure to average
all the best
Khalid -- I can understand the vertical issue. The two sheets might be in an area that is x-size in height. If the filters (identical in each) result in a sheet that is 2x-size in height, they will each get a vertical scroll bar. And the user would have to scroll each independently. We don't have the concept of a scrolling container yet. (I have seen an IDEA in the ideas page asking for that, which would take care of Paolo's concern, but that's not available yet.)
So to that issue, I have no answer.