% Help in Pivot Table.

[#1]

Hi,

I am Using a pivot table chart with

2 Dimension and 1 Expression.

Expresstion - Count(Invoice ID)

I want % of Total Invoice Id on the same chart with new column.

% Calculation should be like this  = Count (Incoice ID) / Count (Total Invoice ID)

It is coming in straight Table but I am not able to make it as per straight table by on the top of Day bucket. We can not do the drag and drop bucket in to in staright table.

For help please find the attached QVW.

Thanks in advance.

[kaushiknsolanki]

Hi,

     Have a look at the example attached here with.

     I have created a chart with % at Customer and % at Bucket level.

Regards,

Kaushik Solanki