How to made actions

[#1]

Hi Guys,

I have table with fileds

YTD

MTD

WTD

PTD

LYTD

LMTD

LWTD

LPTD

My Requirment is

If i clik on YTD i want to display YTD,LYTD  values in a comparision manner.

If i clik on MTD i want to display MTD,LMTD  values in a comparision manner.

If i clik on WTD i want to display WTD,LWTD  values in a comparision manner.

If i clik on PTD i want to display PTD,LPTD  values in a comparision manner.

Thanks

Siva Reddy

[johnw]

If your field is [Period], then you could create a field [Period Group] that includes the two periods you want to see for each period group. Select the period group. Use period as the chart dimension.

[Period Groups]:
LOAD
[Period Group]
,subfield([Periods],',') as [Period]
INLINE [
Period Group:Periods
YTD:YTD,LYTD
MTD:MTD,LMTD
WTD:WTD,LWTD
PTD:PTD,LPTD
] (delimiter is ':');