A
Aylin
Hi ,
THis is probably very simple but not even the people at my work who use
pivot tables etc can tell me how to do it so maybe not?
What I want to do is to display a Heading that looks at filtered
information and prints at the top of the information which filter was
used.
It's a bit like Summing filtered data in Microsoft Excel but instead of
adding the results in one colum using the subtotal I want to see what
the text is in that colum whihc is the one that it is filtered by.
CUSTOMER 1 DATE APPLES $12
CUSTOMER 3 ORANGES
THis is probably very simple but not even the people at my work who use
pivot tables etc can tell me how to do it so maybe not?
What I want to do is to display a Heading that looks at filtered
information and prints at the top of the information which filter was
used.
It's a bit like Summing filtered data in Microsoft Excel but instead of
adding the results in one colum using the subtotal I want to see what
the text is in that colum whihc is the one that it is filtered by.
CUSTOMER 1 DATE APPLES $12
CUSTOMER 3 ORANGES