I have a table with 3 fileds Customer Name, Period(Date), Balances
Customer Name Period Balance
A, 01-May, 100
I would like to display this in a Straight Table/ Pivot Table as follows
Customer Name Balance(01-May) Balance (02-May) Diff
A, 100, 200, 100
DIMENSION-> Customer Name
COLUMN(1)-COLUMN(2) IF YOU WANT (01-MAY BALANCE- 02-bALANCE)
COLUMN(2)-COLUMN(1) IF YOU WANT (02-MAY BALANCE- 01-bALANCE)
HOPE THIS HELPS
Thank You Sunil; It is working
why not you make it correct
so that it will consider as close discussion.
Retrieving data ...