Need Help?

[paulwalker]

Hi All,

I have one table, i want to convert into Cross table,                                                               

Name	SalesPerson	FTD	MTD	YTD	FTD	MTD	YTD	FTD	MTD	YTD
Satyam	Raju	22,675	1,025,432	4,856,952	-	69,524	1,111,426	22,675	1,025,432	4,856,952
Microsoft	Sunil	646	829,684	3,433,276	-	9,197	514,329	646	829,684	3,433,276
Total Close Out		23,321	1,855,115	8,290,228	-	78,721	1,625,755	23,321	1,855,115	8,290,228

This is my table, here first FTD, MTD, YTD into one field like

First FTD, MTD and YTD as Sales

Second FTD, MTD and YTD  as Margin

Third FTD, MTD and YTD  as GrossMargin

Hope you understand...

Thanks in Advance

[paulwalker]

Hi Macro,

PFA,

I have created one bucket..(FTD, MTD and YTD)

It's showing only 2014 data..

when i am click 2013 data it's not reflect..

I am using script level.. Today()..

How to use Max(date) in script level..

Hope You Understand.... PLZZZ