I have to design a Cross-Tab report where the User Account is the Row and Product Type is the Column and Amount is the summarized field....
My problem is for one of the User Account (say 12345) the only product i have to select is "BMG" for the rest i have to select all the products.....
it is something i can't retrict on the query....nor can i use the Group options bcos if i select one group then it wont display for other user also
The layout is like this (although i have data for user 12345 for AIG and BIG)
Product
BMG AIG BIG
UserAccount Det Sum Det Sum Det Sum
12345 5 9 0 0 0 0
23458 5 5 5 5 5 5
IP Logged