Hi 
I have a quick question. 
I have two crosstabs. I need to compare data from them.  

Unfortunately in USS crosstab data are in one metric:
so when I trie to create join between them, I see 24 values from first table and only one value from table two. 

Is it possible to separate values from second table?
Thanks
BR
Jan

------------------------------
Jan Kowalski
------------------------------

#CognosAnalyticswithWatson

Hi Jan,

You need to create a new query:
Query1 is your 1st crosstab and Query2 is your second crosstab.

You will need to create join relationship with your Store Id and Date. Here is a sample:

Then add Query3 items into a new crosstab.

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------