topic B/F , C/F Problem in Pivot Table in QlikView

B/F , C/F Problem in Pivot Table

sakthi266 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: B/F , C/F Problem in Pivot Table

Anil_Babu_Samineni — Mon, 20 Mar 2017 09:31:54 GMT

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

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

Re: B/F , C/F Problem in Pivot Table

sakthi266 — Mon, 20 Mar 2017 13:32:14 GMT

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