I have a question regarding a pivot chart and its calculation in expressions. I've created a chart (pivot table) with dimension the customer number and expression the sales of customers. So far so good. I select dates, for instance year 2013 and I get the sales per customer number in the report. On the other hand, I have an excel file with three columns: customer number, Date_from and Date_to. These customers need to be joined to my QV file and the report should calculate sales only for the mentioned period in the excel file, ignoring the selections in the QV doc. The rest of the customers will be calculated based on dates in the QV doc, but those who are included in the excel file will show sales based on dates in excel. I loaded the excel file in QV doc and joined it with the rest of the customer (using Customer number as key). However, how can I show the sales for customers for specific dates and the rest of the customers for the filtered dates?
Thanks Selva & Jebamalai, Here is the attachment, i've created to make it clear. I've used set analysis, you can see it in the report.
I've loaded from table sales.xls the sales per customer and invoice date. Then i've loaded customer number and specific dates from the second excel "KAM_Flags_Copy.xlsx". All I need is customers included in the second table present sales according to specific dates. Is it possible?
Well, actually, if the customer number is included in the second table the sales should be calculated for the time period "Cust_date_from" and "Cust_date_to" and ignore completely the invoice_date from the first table.
But if the customer number is not included in the second table, then sales should be calculated based on invoice_date from the first table. Any suggestions?