Jerry Seinfield
asked on
cross tab report accumulative amount
Please help:
How can I insert an accumulative amount of values that they are in a cross tab report .
i.e.
YYY
valueA 100
XXY 99
ValueB 200
YYY 99
ACC 300 (valueA+value B)
valueC 100
ZZY 99
ACC2 400 (valueA+value B+valueC)
how calculate ACC and ACC2?
How can I insert an accumulative amount of values that they are in a cross tab report .
i.e.
YYY
valueA 100
XXY 99
ValueB 200
YYY 99
ACC 300 (valueA+value B)
valueC 100
ZZY 99
ACC2 400 (valueA+value B+valueC)
how calculate ACC and ACC2?
If that doesn't work, what are the values?
Are they fields from the database?
Are they formulas?
If they are formulas what are the formulas?
mlmcc
Are they fields from the database?
Are they formulas?
If they are formulas what are the formulas?
mlmcc
ASKER
When I add a calculated member it create a column.
But I'm looking for a row, the ACC should be in the row.
I'm trying with an Embedded summary, but it's repeting same result in all columns. it doesn't work also.
Some are formulas, some come from database, depends on the group
But I'm looking for a row, the ACC should be in the row.
I'm trying with an Embedded summary, but it's repeting same result in all columns. it doesn't work also.
Some are formulas, some come from database, depends on the group
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Solution Guys,
I used this function to a couple of embedded summaries
GridValueAt (CurrentRowIndex, CurrentColumnIndex ,0 )+ GridValueAt (CurrentRowIndex, CurrentColumnIndex ,3 )
It works well.
I used this function to a couple of embedded summaries
GridValueAt (CurrentRowIndex, CurrentColumnIndex ,0 )+ GridValueAt (CurrentRowIndex, CurrentColumnIndex ,3 )
It works well.
ASKER
Thanks for help
See a video demo at: https://www.youtube.com/watch?v=RpAEJqFe4IY