set analysis for * and specific text

[#1]

Hi All,

I have a pivot table with particulars having different text like Collection/ Sale etc.

for this I have to write set analysis as below:

sum({< DocType = {'DZ'} >} Amt)  - for collections

sum({< DocType = {'*'} >} Amt)  - for sales

so I have created 1 excel maintining text and its corresponding doc type.

Particulars   DT  -header

Collections   DZ 

Sale            *

from DB I get column DocType with text as DZ/ KZ/ etc

and I have written common expression as

sum({< DocType = p(DT) } >} Amt) 

this above expression works fine for collection where specific doctype is required

and where all doctypes are required it is not working.

Please can you help me in writing expression which will work for both DZ and *.Administrator

[MK_QSL]

You can use above mentioned two expressions and group them....

Or Create a List Box Showing DZ and *...

and use Sum(Amt) as expression...

[jagan]

Hi,

Can you attach some sample document?

Regards,

Jagan.,

[#4]

HI  Jagan,

Please find an attachment. I have attached one sample.

[MK_QSL]

Go to presentation tab and tick Suppress Zero Values...

[jagan]

Hi,

Can you comeup with an example about what exactly you need.  Try this

num(sum({< Year =, Month =, Day =,DocType = {*},

  PostingDate = {'>=$(=Date(min(CalenderDate))) <=$(=Date(max(CalenderDate)))'} >} Amt), $(varDecimals))

Regards,

Jagan.

[#7]

If in the excel column DocType 'DZ' is available, then it should link with DocType 'DZ' from DB

if excel column '*' is available, then it should link Doctype field in DB with all available data.

In short, Doctype from excel and Doctype from DB should link.

Please can u make 1 change in the excel. change the header from Doctype to DT.

as I have written expression considering DT.

I have tried to explain what exactly I need, if still not clear do as again.