topic Accumulation based on Financial Year Quarters in App Development

Accumulation based on Financial Year Quarters

pradeep92 — Mon, 28 Feb 2022 04:36:25 GMT

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 — Mon, 28 Feb 2022 09:03:08 GMT

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

pradeep92 — Mon, 28 Feb 2022 11:22:50 GMT

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.