I've used this workaround before... it may work for you.
Create a variable, say vSelection. Add that to an input box. In the Constraints Tab select Predefined Values in Drop-Down. Then check Listed Values and add this:
='" ", "' & Concat($Field,'","') & '"'
to the expression box. This will give you a list of all available fields. You can also input whatever you'd like and separate them with a semi-colon if you want to narrow your options.
Then within your table use =$(=vSelection) as your dimension and Profit% as your expression. This should give you the info you are looking for.
Have a look at the sample file.
Is this what you are looking for..?
Sample.qvw 126.5 K
Thanks for your example.
Looks like almost near to what I want.
Actullay, I want output table should be showing profit as below.
If I select Customer Country (I am talking about COLUMN NAME and not individual country), below table should be appear....
Customer Country Profit% Australia 11.43% France 21.43% Germany 15.00% Italy 12.50% USA 6.67% TOTAL 13.06%
same way if I select Product, below table should be appear.
Product % Profit EGGS 5.00% OIL 15.00% PHONE 8.75% RADIO 24.00% SOAP 25.00% TV 10.63% TOTAL 13.06%
Also, I dont have any idea how can I have COLUMN NAMES as a selection. The way you have explained is 100% accurate if I consider wrt to whatever explained in my question, but after rechecking I found that my explanation itselt was wrong at that time.
Please let me know if this is possible.....
Thanks in advance.