i have such info from the client and the data as such. i remember can use crosstable method , but i cant remember to to write.
Requirement is, client wanted it to be displayed out in a Bar Chart. How can I do that?
Is this you are looking for?
but need to create it in a bar chart
Then you might be having Product wise sales,target,actual sales, are you?
If yes, then take Product as Dim
and measure cud be:
and In number format check Show in % and upto 2 decimal
else after implementing Cross table,
at UI level, in bar chart,
Take Product as Dim
And expression cud be: %Contribution and same setting in number format
i will try that out. Balraj. Thanks.!
CROSSTABLE( ProductName, Percentage)
LOAD Recno() as ID, [Product A],[Product B],[Product C],[Product D],[Product E]
Retrieving data ...