Is it possible?

[#1]

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

[nagaiank]

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.

[#3]

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