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?
Quote from: hrk551 on 21 May 2014 02:36:22 PM
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.