click option to minimize or maximize the data

[akber.431]

Hi, Can anyone help me in this format.


i have cheque details for the customer by months but i want to fix the option (+) or (-) on the cell Month. (eg like. subtotal)


if i click on may it should be drag up or down list , i hope you understand.

A B C D E
May French World 9,696.00 000098 12-May-11
House of Perfumes 7,296.00 001604 08-May-11
Studio fragrance 1,408.00 106321 10-May-11
Channel Perfumes 4,200.00 472326 28-May-11
Smell Trading 1,032.00 000115 30-May-11
thanks in advance

 

[GlennUK]

Nope, I've read it twice, and I don't understand. Are you saying that you want to group by month? If you data is in date order, then have an extra column of month e.g. =TEXT(cellref,"mmm") , and do the subtotal ... Data Subtotal ... on that ( Count on change of month ) ... it will generate an outline automatically. That's a complete guess of course.

 

[akber.431]

Hi,

Thanks for replying on my query. but in i want to say that i have following information ,

A B C
July Thanima Perfumes 2,880.00
Jadwil Perfumes 200.00
Wardan Al Maghrib 500.00
Aroma Gift 2,256.00
Al Jumeira Studio Stores 7,140.00

the above text is an example of query and i have no of months break May, June, July, aug so on. what i need i want to fix a formula or condition which i can maximize or minimize the information.

for eg. i have bulk information on customer balances by months i dont want to fix filter function. i just want to fix month cell a button which carries (+) or (-) like if you have seen in subtotal, if i want to c month amounts i can c it without checking all information



i

 

[GlennUK]

And have you thought about my suggestion of having the month on every row, and subtotalling on that? Wouldn't that do exactly what you want?