Aggregation in Pivot Table

[manojkulkarni]

HI Friend,

I am having below data in pivot table with date column expanded. I am expecting the results below in collapsed mode for same pivot table.

What should be my expression ? Appreciate your help.

	Date	Brought Forward	Opening	Closing	Carry Forward
Process - 1	04-02-2017	6	0	6	0
	03-02-2017	3	6	3	6
	02-02-2017	9	4	10	3
	01-02-2017	0	19	10	9
Process - 2	04-02-2017	7	0	6	1
	03-02-2017	3	6	2	7
	02-02-2017	5	4	6	3
	01-02-2017	0	15	10	5

Expected Out Put

Brought Forward	Opening	Closing	Carry Forward
Process - 1	6	0	6	0
Process - 2	7	0	6	1

[sarvesh]

Please refer below mentioned link:

Dimensions and Measures‌

Hope it helps..

Regard's

Sarvesh Srivastava

[sunny_talwar]

What is your current expression?

[manojkulkarni]

Sum(BroughtForward)

Dimension: Process & Date

[sunny_talwar]

May be try this

FirstSortedValue(Aggr(Sum(BroughtForward), Process, Date), -Aggr(Date, Process, Date))