Create/Show Grand Total Column

ArthurA
ArthurA
edited February 18 in Modeling

Hi everyone, is there anyway i can create/show the grand total of all fiscal year in column time dimension? like if i have FY23,FY24,FY25 and FY26, then the next column is Grand Total. Thank you.

Update: FY columns are from Time dimension and not item list.

image.png

Best Answer

  • lokeshm
    lokeshm
    Answer ✓

    Hi , you can include the Total of All periods in the time settings to get the sum of All FY. You can also use time range to achieve this.

    image.png
    image.png

Categories