Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Possible by using pivot table with pivot option expanded
How do i do in a pivot table ???
Please check my Qvw
PFA
I used to follow this kind of trick PFA if u like
Gr8, you mark your ques only to be correct answer............
Ha ha
It was by mistake
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
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))))
)
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