Hi,
basically my cross tab is based on YTD , FY > So please have a look at the crosstab picture along with this post.
1. I want to remove the ACTUAL column from YTD but want it in FY parent Column and likewise I want to display FORECAST only in FY column but not in YTD.
My YTD and FY are coming from a field Periodicity.
So how do I acheive this ?
2. I want to add a field SCI but that is not contained under field Periodicity > so when I try to put that in cross tab it shows up in YTD and FY columns but thats not how i want.
WOuld like to see as YTD | FY | SCI_TARGET | SCI STATUS. Both SCI are individual fields hence I cannot group it to YTD OR FY.
3. Can I format fields individually in the columns ? As from the list you can see I have some small nos. but some very large nos. I want to make those Large numbers to be in $xx.xM and some of the other numbers as % while leaving the rest as it is.
Can I achieve this sort of combinations.
hope it makes sense?
Please advise.
basically my cross tab is based on YTD , FY > So please have a look at the crosstab picture along with this post.
1. I want to remove the ACTUAL column from YTD but want it in FY parent Column and likewise I want to display FORECAST only in FY column but not in YTD.
My YTD and FY are coming from a field Periodicity.
So how do I acheive this ?
2. I want to add a field SCI but that is not contained under field Periodicity > so when I try to put that in cross tab it shows up in YTD and FY columns but thats not how i want.
WOuld like to see as YTD | FY | SCI_TARGET | SCI STATUS. Both SCI are individual fields hence I cannot group it to YTD OR FY.
3. Can I format fields individually in the columns ? As from the list you can see I have some small nos. but some very large nos. I want to make those Large numbers to be in $xx.xM and some of the other numbers as % while leaving the rest as it is.
Can I achieve this sort of combinations.
hope it makes sense?
Please advise.