Table of this format

[#1]

Hi All,

I want the table of this format.

I have data for DTD(Trading), MTD(Trading), YTD(Trading), DTD(Sales), MTD(Sales) and YTD(Sales).

Thanks & Regards,

Keerthi

[sujeetsingh]

Possible by using pivot table with pivot option expanded

[#3]

How do i do in a pivot table ???

Please check my Qvw

[Anonymous · Accepted solution]

PFA

[nizamsha]

I used to follow this kind of trick PFA if u like

[Anonymous]

Gr8, you mark your ques only to be correct answer............

[#7]

Ha ha

It was by mistake

[#8]

Hi Nitin,

You have used one single expression for the table.

What if i have multiple expressions such as MTD, DTD and YTD.

Attached is the Qvw.

Thanks & Regards,

Keerthi

[Anonymous]

Then we have to use if as below:

if(CATEGORY='Trading',

if(Type='DTD',sum(TradePrice),

if(Type='MTD',sum(TradePrice),

if(Type='YTD',sum(TradePrice)))),

if(Type='DTD',sum(SalePrice),

if(Type='MTD',sum(SalePrice),

if(Type='YTD',sum(SalePrice))))

)

[#10]

Thanks a lot nitin

Also i want to know how to forecast data for next one month .

Do you have any examples of forecasting ?

Thanks & Regrads,

Keerthi