Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
I have attached format report which is in pivot table I Want to show Highest Division target wise ( I.e. Warren Should come first) and
then sorting on annual target .
It is urgent please share your experience.
Vikas
Hi Vikas,
Pls go to Chart properties -> Sort Tab -> Check Expression from Sort By (For Dimension Division)
-> use Sum([Annual Target]) Code and select Descending ->Apply
Thanks
Kunal thanks for reply actually I have done this but not able to get desire sorting.
Vikas
Vikas, I am geeting this type of sorting applying the same sorting chriteria.
Is that what you are looking for?
I have also getting same thing in excel when i try in test environment but live scanario is giving me wrong result let me check whether there is problem in source data !
Vikas