Skip to Content
0
Former Member
Mar 12, 2010 at 11:02 PM

Show in Columns values (import) depend of the combination of characteristic

51 Views

Hi All

I have a requirement about Query

Let me try to explain the details:

The user want to give me in excel file (or text file ) the combination of some characteristics that the report need to filter in reports, he say, for example If I specify combination of ZSOURCE-ZCOMPCODE-ZZONA, please give me the result in one column (zresult_1), and in column zresult_2 don't show result, write $0.00.

Is it possible specify in a query condition that contain characteristics (3, 4 characteristics, etc)?, or something that the query take for show values depend of conditions?

I know about condition, excepcion, but as I understood this can be only for key figures, I can't say to system if characteristic is equal a, etc.

The idea is that all the combination that the user tell me only be displayed in one column, and the rest in other, etc.

I made an example on link, please try to show it,

link[http://docs.google.com/Doc?docid=0Ad28qFkDq1jiZGd6NGdwdHBfMWdrbjdrNm5w&hl=en]

I will appreciate your help

Thanks in advanced

Al