Skip to Content
0
Jun 15, 2018 at 08:14 AM

Sum of merged dimension webi

354 Views

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