Pivot table Problem

[#1]

Hi Everyone,

Here i'm not getting that how to show the report  in this type of format in Pivot table.. the format is as below-

I want to show  on the top Gross Sales in one column. In Gross Sales column we want to show the different five column

PY , Target, Act , vs PY% and PY. as in the below fig . I am unable to do this .

Please anyone help me how to do these things.

[#2]

Hi Manoj,

Are Gross Sales, Qty, and Gross Margin all in the same dimension (or field)?

If so, then just drag and drop that dimension on top of your expressions (horizontally).

Regards.

[#3]

Hi,

     You can use Pivoting to do this.

Press the left mouse button and keep it depressed while dragging the mouse cursor up above the expression label row.

For using this,  make sure that Allow Pivoting option is enabled in Presentation tab.

I hope this help you

Regards,

Ashutosh

[tresesco]

See this link, might help you: Merge headers in pivot table