Pivot Table - Format

[pkelly]

Hi All

I am trying to acheive the following format in a pivot table...

	Product	Product A		Product A
Customer		Var Value	Var %	Var Value	Var %
CustomerA	Sales
	Gross Profit
CustomerB	Sales
	Gross Profit
CustomerC	Sales
	Gross Profit

The only way I can see to do this is to create a stand alone table with my Var Value and Var% as fields.

Is there another (easier) way of doing this from within the pivot table...

EDIT:

Second product column should read product B

Regards

Paul

[pkelly]

Any ideas?

[#3]

It is a matter of dragging your dimensions and expressions into the right place. See attached

[pkelly]

Thank you - whilst this is close it is not the layout which I am looking for...#

For sales and gross profit I want to see Var Value and Var % for each product.

Any help greatly appreciated...

[Oleg_Troyansky]

I realize it's a bit late, but...

- You can create a calculated dimension using function Valuelist() and condition your expressions based on the value. For example:

Dimension = ValueList('Var Value', 'Var %')

Expression:

if ( ValueList('Var Value', 'Var %') = 'Var Value', sum(Sales), sum(Sales)/sum(Total Sales))

As a side comment - I'd challenge this sort of presentation where you show both Sales and GP, and both are presented as values and as %. In my opinion, the table becomes too busy and hard to read. I'd look for a better way to visualize this information.

[pkelly]

Thanks Oleg - I will give it a go...

Agree with you 100% on the presentation but this is the layout our user wants to see.