Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Country States Rate
India Delhi 5%
India Mumbai 10%
India Kerala 3%
To something like below in a pivot or straight table
India Rate
Delhi 5%
Mumbai 10%
Kerala 3%
What is the Logic behind this? Please explain...
Otherwise you can take States as Dimension and use label as Country or India
Hi,
it would be helpful if you could elaborate a bit on what is this "this" which you're trying to achieve. That set of figures you have in your post could be interpreted in many ways ...
HTH
Take a look at this
Just wanted to change the header grouping from left side to top. Don't know how to say..its like
Australia Sydney 8%
Australia Canberra 4%
Australia Perth 2%
I want something like the grouping below either in straight or pivot table.
Country Rate
India
Australia
Sydney 8%
Canberra 4%
Perth 2%
Create a Pivot Table
Dimension
Country
State
Expression whatever you want!
How about removing the country dimension, then naming the States dimension something like =only(Country)
Now when you select a Country from a list box you'll get your format.
If i am getting your requirements right it is like that , you want to see all the state under country India ?
if this is the req. it is very to easy to make in pivot table.
PFA
Regards,
Ankit
Use pivot with Charts
Anikit,
the one which you did is not my requirement...check my query above. yours is just normal pivot table with existing field name.
