Comparision between two months

[hrk551]

Comparing two periods: Period 1, Period 2
Period 1       Period 2
    1
    2
    3             3
    4             4.1
    5             5
    6             6.1
                  7
                  8

I did 2 queries Period 1, period 2 and using a list and using 0..1 on both sides, cannot use crosstab- multiple measures and text data also

Period 1: Feb2014  -- wrong total
Period 2: Mar2014  -- Correct total

Period 1: Mar2014  -- wrong total
Period 2: Feb2014  -- Correct total

I dont know if I am clear?

[MFGF]

Comparing two periods: Period 1, Period 2
Period 1       Period 2
    1
    2
    3             3
    4             4.1
    5             5
    6             6.1
                  7
                  8

I did 2 queries Period 1, period 2 and using a list and using 0..1 on both sides, cannot use crosstab- multiple measures and text data also

Period 1: Feb2014  -- wrong total
Period 2: Mar2014  -- Correct total

Period 1: Mar2014  -- wrong total
Period 2: Feb2014  -- Correct total

I dont know if I am clear?

Ummmmmm...... I'm struggling to understand. Can you explain this in simple terms for a muppet like me? :)

MF.