Cross table mixing same dimension

[GuiCoRe]

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

Code Select Expand

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