Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have the Pivot Table Processwise, daywise Brought forward and Carryforward as Shown in attachment. If I Collapse All i want to Show ProcessWise Last Day Brought Forward Instead it is showing Cumulative As Process 1 Brought Forward is 174. Value Required is 46
Please help on this issue ASAP.
FirstSortedValue(Aggr(Sum([Brought Forward]), Process, Date), Aggr(Date, Process, Date))
Try like below and then use sum as total from expression tab
Aggr(Sum({<Date = {'$(=Max(Date))'}>}[Brought Forward]),Date)
FirstSortedValue(Aggr(Sum([Brought Forward]), Process, Date), Aggr(Date, Process, Date))