Accumulation based on Financial Year Quarters

[pradeep92]

Hello Guys,

I have a  requirement where I need to accumulate the data for each financial year with its quarters.

eg: for FY2022Q1 , it should start with 94,229 again in rangesum and sum up its Q2,Q3 and Q4 quarters accordingly.

Expression that I used,

RangeSum(Above(Sum({<PI_Quarter_Flag ={1},Fiscal_Year_Qtr>}ACTUAL_HARD_SAVINGS_CUSTOMER/1000), 0, rowno()))

Please help me out on this!

[chris_djih]

Why don't you use a Pivot table, make Quarzters the second dimension and show sub totals?

[pradeep92]

Hello Chris,

Thanks for the response.

I would like to show it in bar chart … I thought of fitting the requirement into a simple table and then convert it to Bar chart.