Dear all
I have a data on basis which chart is created using pivot.
What I am trying is to maintin the output format irrespective of data
Let me clear with a simple example. There are two divisions-EAST & NORTH
EAST has placed orders for PC PRINTER and SCANNER
NORTH has placed an order for PC and LAPTOP.
so if i create a chart / table without any filterarion on basis state it would show
PC PRINTER LAPTOP SCANNER and related values below
PC PRINTER LAPTOP SCANNER
EAST 9.... 100..... ...... 87
NORTH 9.... ...... 100 .....
Now in event I filter on basis EAST, I output get would be as below
PC PRINTER SCANNER
EAST 9 ..... 100 ..... 87
However I want it to be as
PC PRINTER LAPTOP SCANNER
EAST 9 ..... 100 ..... ..... 87
Can this be done ??? Please guide. There are multiple items and 5 regions so I want to maintain the formats in presentation... one way is to include dummy records.. but as said there are multiple items and then it becomes a tedious task. Please help
I have a data on basis which chart is created using pivot.
What I am trying is to maintin the output format irrespective of data
Let me clear with a simple example. There are two divisions-EAST & NORTH
EAST has placed orders for PC PRINTER and SCANNER
NORTH has placed an order for PC and LAPTOP.
so if i create a chart / table without any filterarion on basis state it would show
PC PRINTER LAPTOP SCANNER and related values below
PC PRINTER LAPTOP SCANNER
EAST 9.... 100..... ...... 87
NORTH 9.... ...... 100 .....
Now in event I filter on basis EAST, I output get would be as below
PC PRINTER SCANNER
EAST 9 ..... 100 ..... 87
However I want it to be as
PC PRINTER LAPTOP SCANNER
EAST 9 ..... 100 ..... ..... 87
Can this be done ??? Please guide. There are multiple items and 5 regions so I want to maintain the formats in presentation... one way is to include dummy records.. but as said there are multiple items and then it becomes a tedious task. Please help