Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
how to we get above functionality in pivot table
for eg:my sample data
date | chip | a | b |
1 | c1 | 100 | 700 |
2 | c1 | 200 | 800 |
3 | c1 | 300 | 900 |
4 | c1 | 400 | 1000 |
5 | c1 | 500 | 1100 |
6 | c1 | 600 | 1200 |
I want column d such that d1=a+b=800 for date 1
for date2=date1 bal+b(of date2) -a(date1)
output
chip | 1 | 2 | 3 | |
---|---|---|---|---|
c1 | a | 100 | 200 | 300 |
c1 | b | 700 | 800 | 900 |
c1 | bal | 800 | 800+800-200=1400 | 1400+900-300=2000 |
This?
Dimensions:
chip
date
Expressions:
=Sum(a)
=Sum(b)
=If(ColumnNo(TOTAL) = 1, Sum(a) + Sum(b), RangeSum(Before(bal), Sum(b), -Sum(a)))
Here bal is the label for the third column (so self referencing label)
This?
Dimensions:
chip
date
Expressions:
=Sum(a)
=Sum(b)
=If(ColumnNo(TOTAL) = 1, Sum(a) + Sum(b), RangeSum(Before(bal), Sum(b), -Sum(a)))
Here bal is the label for the third column (so self referencing label)