Hi Guys
I have a report in which i am using union bcos data is coming from 2 different data sources.
In first query i have product number,prodname,qty, 2 different cost c1(measure)and cost c2(measure).
Prodno,prodname,qty,c1,c2,Total(qty*(c1+c2))
In second query, i got custno,sales and one more column which represent dimension for c1 and c2.There is no prodname column here
custno,sales.
In the second query i can filter sales amount by c1 or c2 for each customer.
when i represent this in report layout.
i need to have below query items
state,city,total,sales
and i need to have value prompt where i should be able to select c1 or c2 or both.
Depending on the selection,i need to see the changes in total and sales amount.
if anyone can help out how to filter this report.Its very urgent.
Hope i tried to explain properly.
Thank u
Regards
Kumar
I have a report in which i am using union bcos data is coming from 2 different data sources.
In first query i have product number,prodname,qty, 2 different cost c1(measure)and cost c2(measure).
Prodno,prodname,qty,c1,c2,Total(qty*(c1+c2))
In second query, i got custno,sales and one more column which represent dimension for c1 and c2.There is no prodname column here
custno,sales.
In the second query i can filter sales amount by c1 or c2 for each customer.
when i represent this in report layout.
i need to have below query items
state,city,total,sales
and i need to have value prompt where i should be able to select c1 or c2 or both.
Depending on the selection,i need to see the changes in total and sales amount.
if anyone can help out how to filter this report.Its very urgent.
Hope i tried to explain properly.
Thank u
Regards
Kumar