try this one
ins second formula you can try like this
DATETRUNC('quarter',[Order Date]), you get Q1, orQ2
and then in first formula
if (inreportquarter?)='Q1' then (grossprofit) end;
is [gross profit %] a formula? if yes then please share the details of the same.
Gross profit new: sum(if datetrunc('quarter',[Rptg Yr Qtr Abbrv])= [Report Quarter] then [Gross Profit] else 0 end)
Total Sales new: sum(if datetrunc('quarter',[Rptg Yr Qtr Abbrv])= [Report Quarter] then [Total Sales] else 0 end)
New Gross Profit %
[Gross profit new]/ [Total Sales new]
Let me know If this helps
Thank you so much Mahfooj, really creative thinking. Owe you a pint!
Just mark my answer as correct If you found it helpful that's it. That will be my treat