NEED help with Dimension Problem

[#1]

i have got a field called Paymode in this its shown that how a person has paid the amount for example CC, DD, CQ

CC stands for cash payment

DD stands for Demand draft Payment

and CQ stands for Cheque Payment

For example

HolderID      paymode     AMOUNT

112               CC               10000

113               DD               40000

114                CQ              60000

114                DD                10000

114                 CC               60000

115                  CC               10000

115                    DD               20000

116                    CQ               30000

116                    DD               40000

117                    CC                 30000

117                    CQ                  50000

Now i want to show a analysis on how many people have paid through CC,DD,CQ

so its counting 114 in all the three CC DD and CQ

I have used expression count(distinct(HolderID )) with dimension paymode

its showing CC- 4

               DD- 4

               CQ- 3

In BAR CHART I AM GETTING

CC

I want my analysis like this

CC,DD,CQ- 1

CC            - 1

DD          -    1

CC,DD      -     1

CC,CQ       - 1

DD,CQ      -  1

[#2]

In BAR CHART I AM GETTING

CC- 4

DD- 4

CQ- 4

I want my analysis like this

CC,DD,CQ- 1

CC            - 1

DD          -    1

CC,DD      -     1

CC,CQ       - 1

DD,CQ      -  1

Can i do it like this ? if yes How??

Please Help

[sujeetsingh]

simple man just write down flags and Group By HolderID

===if(paymode='CC' and paymode='DD' and paymode='CQ','CC,DD,CQ') as CCDDCQFlag

some thing like this

[anbu1984]

Try this

[tresesco]

See the attachment.

[sujeetsingh]

Here is my concept in sample nice anbu