Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create a pivot table with 3 dimensions on Row, one on column and I want to show Totals for the dimension on column but I want to show Totals only when there are multiple weeks selected. default view is a bookmark with current week selected so that is one week and for that case I do not want to Show Totals.
I also have 3 metrics, so it will show totals per 3 metrics but otherwise I want those 3 metrics permanentely calculated
thank you
You can add the Week dimension twice to columns - one with Totals and one without. Then add "Show column if" as count(distinct Week)=1 on the Week-column without total and count(distinct Week)>1 on the other.