Multiple Headers

[#1]

Hello Friends,

As I need to create a pivot table using the format as in the attached.

Regards

Chriss

[#2]

You can "fake it" using text boxes. See attached.

[#3]

Hi,

Thanks for your reply, I have done it through text object only but the customer wants on selection of Year the value has to display, for this any workaround ...

Regards

Chriss

[Anonymous]

Hi,

Looks like a standard pivot table to me.

Create a chart of type Pivot, with 2 dimensions (PAID/REDFLAG and MonthName) and two expressions (Amount sum and Shipment # count). Drag MonthName from column 2 across to the right, so that a vertcial blue column placement line appears, then drop it.

Total row can then be achieved by selecting Show Partial sums (from presentation tab) for the PAID/REDFLAG column, and set as the first line by choosing Subtotals on Top (from presentation tab again).

Regards,

Jonathan

[#5]

The text can be based on the selection. Take a look at the attached example.

[Anonymous]

Example attached that sets up a Pivot table and doesn't need any fake text labels. Label can then be clicked on to select that Month, and drill down to underlying dates if available at that level.

Jonathan