Display Differences by Period

[#1]

I have a table with 3 fileds Customer Name, Period(Date), Balances

Sample

Customer Name Period  Balance

A, 01-May, 100

A,02-May, 200

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

Appreciate support

[SunilChauhan]

DIMENSION-> Customer Name

FIRST EXPRESSION

SUM(IF(Period  ='01-MAY',Balance))

SECOND EXPRESSION

SUM(IF(Period  ='02-MAY',Balance))

THIRD EXPRESSION

COLUMN(1)-COLUMN(2)                         IF YOU WANT (01-MAY BALANCE- 02-bALANCE)

OR

COLUMN(2)-COLUMN(1)                               IF YOU WANT (02-MAY BALANCE- 01-bALANCE)

HOPE THIS HELPS

[#3]

Thank You Sunil; It is working

[SunilChauhan]

why not you make it correct

so that it will consider as close discussion.