Hello Everyone, I need your help in formatting pivot table,

Wed, 20 Nov 2013 06:50:18 GMT

Hello Friends,

I am trying to make a Table for YTD,MTD,QTD using pivot table,

My designing portion included:

Dimension: Channel,

Expressions : PY sales,CYsales,vsPY% Sales,PY Quantity,CY Quantity,vsPY% Quantity,

So in this task i need to create table like as below in which i have again a calculated dimension which may be based on expressions like:

PY Sales, CYSales, vsPY%Sales comes under a common Dimension Sales, similarly,

PY Quantity,CY Quantity,vsPY% Quantity comes under a common Dimension Quantity

How can it be possible if we donot have these dimensions as a field in our data base and also all our expressions are calculated by some calculations, they are not direct Fields.

Please Reply ASAP,

Thanks in Advance and Regards.

Re: Hello Everyone, I need your help in formatting pivot table,

sujeetsingh — Wed, 20 Nov 2013 06:54:36 GMT

If possible give me a sample

topic Hello Everyone, I need your help in formatting pivot table, in QlikView

Hello Everyone, I need your help in formatting pivot table,

Re: Hello Everyone, I need your help in formatting pivot table,