Hello,
I have some trouble (again).
I have a cross table like this: see attachment:
- A prompt which contains: 201201, 201204,201301...
- "AC" And "FC" are actuality
- "Period choose" are the result of prompt
- Q1 contains the parent of the Year choose in the prompt, ex for 201201 => Q1 2012 (I used item(descendants (Ancestor([Period choose],2),1),0))
- Q2 contains the parent of the Year choose in the prompt, ex for 201201 => Q2 2012
- ...
It works well.
Bu now, I want to do 2 things:
1- Display FC or AC figures pending the period choose
If the user choose 201201 I will display figures in AC for Q1, FC for Q2, FC for Q3 and FC for Q4
If the user choose 201205 I will display figures in AC for Q1, AC for Q2, FC for Q3 and FC for Q4
This work with Conditionnal formating, but it's not optimize. How can i do better ?
2- Now, I want the full year (QQQQ in the attachement):
The full year will be Q1+Q2+Q3+Q4.
but how can I do ? Typically, I should write something like: if the period is 201201 the total will be Q1 AC + Q2 FC+ Q3 FC + Q4 FC
BUT i have other colum in my cross table where Q1+Q2+Q3+Q4 works perfectly...
Could you help about this ?
Thank you,
GuiCoRe