Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
name month amount
a aug 500
a sep 500
a oct 500
a nov 500
-------------------------------
total 2000
i want to display table like this
name month amount
a aug 2000
a sep 1500
a oct 1000
a nov 500
-------------------------------
total 0
Hi,
try this
sum
(total amount)- rangesum(above(sum(amount),1,rowno()))
see the attached file
For one employee its ok
but i want show as below
My sourse is below | ||
Name | Month | Amount |
X | Aug | 500 |
X | Sep | 500 |
X | Oct | 500 |
X | Nov | 500 |
X | Dec | 0 |
XX | Aug | 500 |
XX | Sep | 400 |
XX | Oct | 300 |
XX | Nov | 300 |
XX | Dec | 0 |
I want to show | ||
Month | X | XX |
Aug | 2000 | 1500 |
Sep | 1500 | 1000 |
Oct | 1000 | 600 |
Nov | 500 | 300 |
Dec | 0 | 0 |
Regards
Sankar
HI,
Create a pivot chart with dimensions as Month, Name and expression as Sum(values)
Now you can drag the Name field as take it to the above of the expression.
Hope this helps.
Regards,
Kaushik Solanki