Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community
I am Attaching sample file..how to find the Total Sales,and Rank in pivot table...
I dont want to use calculated dimensions..so i want to this one in pivot table with some useful expression.
i want to show only in pivot table.
can u please help me .
The rank is based on the sum(Sales) so if your sum(Sales) is same for more than one Field values then the rank will show same for all those field values.
If possible can you please post the sample where you are getting any issue?
Please take a look at the attachment.
Hi
First select the chart pivot table => in the dimension place first the Product then Customer => Next in Expression Put Sum(Sales).
After that go to sort tab and sort according to the way you want
Dear Sudeep,Thanks For giving reply..
But i want to use all the dimensions i am having,for example here i have two dimension,in other case i have 5 dimensions ,
if i do like this i am getting rank 1 for all the persons when i expand the symbol,When I use collapse all button i am getting the Rank what u said ...
So Please kindly correct me the error
hi,
what u r saying is it correct way???
i have to find the rank. in pivot table
The rank is based on the sum(Sales) so if your sum(Sales) is same for more than one Field values then the rank will show same for all those field values.
If possible can you please post the sample where you are getting any issue?
Dear Sudeep
U r way doing is exactly correct ..but i am not getting in the same way.if i am doing.i have 5 dimensions sudeep,
how can i do it..it is not possible to add a sample qvw ..so please understand and let me give the solution...
i have different sum(sales) are there ..