B/F , C/F Problem in Pivot Table

[sakthi266]

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.

[Anil_Babu_Samineni]

Try like below and then use sum as total from expression tab

Aggr(Sum({<Date = {'$(=Max(Date))'}>}[Brought Forward]),Date)

[sakthi266 · Accepted solution]

FirstSortedValue(Aggr(Sum([Brought Forward]), Process, Date), Aggr(Date, Process, Date))