Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is is possible to achieve something like this:
Want to show region n Manger both in the same report......
Amt | Sales | Sales% | |
Region 1 | |||
Manager1 for Region A | |||
Manager2 for Region A | |||
Manager3 for Region A | |||
Manager4 for Region A | |||
Manager5 for Region A | |||
Region A Total | |||
Region 2 | |||
Manager1 for Region B | |||
Manager2 for Region B | |||
Manager3 for Region B | |||
Manager4 for Region B | |||
Manager5 for Region B | |||
Region B Total |
If your Region 1 is Region A , and Region 2 is Region B, it is possible, as it is a standard pivot table chart with Region and Manager as dimensions and Sales and Sales% as expresions.
thanks for looking into this
yes my region 1 is Region A.....
in pivot it is showing as
Region, Manager, Sales .....
When i click on Region it shows me all the managers for that region.
i want region to be followed by manager....the output shud be like dis:
Region1
Manager 1 for region1
Manager2 for region 1
Total for Region 1
Region2
Manager1for Region2
Manager2 for Region2
Total for Region2