Hi
I have 2 queries and merged the dimension from 2 queries, then created detailed variable for same merged dimension, created variable to sum the total numbers of ID using detailed variable ... counts are correct but display is the problem:-
Q1---- ID, code
Q2---- ID, code
merged dimension---- m_code and m_ID from Q1,Q2
detailed dimension --- d_code using m_code with associated dimension ID
measure --- sum(count([m_id]) ForEach ([d_code]
cross tab
d_code coming as code1, code1 in 2 rows
count coming as 56 for code1 , 120 for code 2 in 2 rows
result expected:-
d_code as code1 in single row
count should come as sum of (56, 120) in single row
header is bands like 0-4, 5-8, 8-12
hope I explained it properly
regards