Query to calculate the data beneath the exixting set of Data

Question

Hi Team,

I need to calculate the below data in my output but able to do so, kindly support me to prepare the workflow to get the out as below.

i have already created a workflow and released attached output, however i need to have below calculation from Column BI to BM. LKR value is to be taken from Cell BK 71 and FX value is to be taken manually 0.0032.

Thanks Deepak

Book1.xlsx

Screenshot 2026-02-24 150734.png

jrlindem · Answer

@Dshukla  can you describe further what you're trying to do?  Are you trying to do something with the value in BK71 or are you trying to create the Grand Total row for BI through BM?

Also not sure what "LKR" is.  Is that further columns "L" and "K" and "R" that are not shown in your example data?

Additional context would be useful.  -Jay

quintinmorrow · Answer

In Alteryx, calculating data beneath an existing summary usually comes down to using a Multi-Row Formula or a Running Total setup, depending on what you’re after. I’ve handled similar cases by sorting the data first, then applying window-style calculations. Getting the grouping right is key, otherwise the totals end up bleeding across categories unexpectedly.