Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ':');