Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have this table below which is based on fiscal year:
I need to have add a total per quarter e.g. OCT NOV DEC 3Q JAN FEB MAR 4Q.... the total quarter's value should be the sum of all the months in the quarter. The values for each month of the rows and columns are calculated individually using set analysis.
how can i achieve this without editing data load? thank you very much.
Just add the field Quarter as a dimension and check "Show Partial Sum" under presentation for the Quarter field