Group

[#1]

Hi,

I'm creating a straight table where i'll have three dimensions,Audit names,Count and City.

i want to create a sub-Category kind for the record to Audit name.

e.g->  Sales in Z not in P is one record with Count as 235 and  City IL.Below three records should come under Sales in Z not in P record.Once user select the main category,subcategory should expand and display.

Overall in Z not in P

List of Products in Z

Products not in either

Thanks.

[kiranmanoharrode]

Expand Facility is not available in straight table chart type.

You must have to use Pivot Table