We need to spilt into two columns and two rows

[Srinivas]

Hi All,

I Have Straight table in that fields like item, item name, Sales Qty(Combination of Sales1+Sales2) like i have ....

Here my requirement when i click on Sales Qty then split into two columns like Sales1, Sales2....so on.How can achieve this problem

Could you please help on this.

Regards

Munna

[simondachstr]

Sounds like a classic pivot table with expanding instead of clicking?

[Srinivas]

Hi Martin,

Can you please send me if you have any sample application.that would be better for me.

Advance Thanks

Munna

[simondachstr]

Change your chart from a straight table to a pivot table and start playing around, dragging and rearranging the dimensions. It's easy, you'll figure it out faster than you think.