Thanks for the reply seems like it works for the scenario I was testing.
Could you please let me know why did you use the max function in the below cal when sum also works the same
MAX([Furniture profit])+MAX([Envelope Sales])
just to know in case I need to use the same way while testing
It's a way of reminding myself that the calc is already aggregated. I also tend to name my fields things like [LOD Furniture Profit], again just to remind me what's going on at a glance.
Glad it worked for you.