Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Suppose i have two fields in dimension tab ie.
State and city
Maharashtra pune,mumbai
Bihar patna
uttar pradesh lucknow,allahabad,kanpur,noida
punjab ludhina,chandigarh
And in expression tab i have sales
Now i want show the chart as
MAharashtra Pune sales
Mumbai
UP and Punjab lucknow
allahabad sales
kanpur
noida
ludhina
chandigarh
Here sales is individual city sales
Hi ,
You can use straight table which will display data as required .
Hi,
Use Pivot table, with State as first dimension and city as second dimension. Now use
=Sum(SalesFieldColumn) as expression.
Hope this helps you.
Regards,
Jagan.