nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Cube using multiple data sets

olivia08

I'm trying to create a data cube where the resulting output looks like this (see attached file). I have it working to get columns 1 and 2 because the data came from one primary dataset. However, the counts in column 3 come from a separate dataset. So I tried to incorporate that dataset in the cube but I'm not able to get it to display correctly. I thought that I needed both columns 2 and 3 to be set as a summary field, but it would only let me use the primary dataset for a summary field. Any help would be appreciated.

Find more posts tagged with

Comments

Hans_vd

Try creating a joint data set and build the cube based on that new data set

olivia08

Thanks. I was able to create a joint data set for the data and that seemed to get me closer. The only problem I'm having now is on the summary field of the cross tab. I summarize two fields (Total Users, Super Users) based on the Month and Group (see attachment). My dataset returns the values for each of these. However, it appears the results are displaying as the sum of all of the values for that group and the entire timeperiod...rather than just showing the one value coming from the dataset. I do have the Aggregation set to SUM and I'm guess that is the problem. But I don't see anything else in the function list to pick that would work. Any ideas?

Hans_vd

Probably a couple of weeks too late but this would be the answer: use the FIRST function instead of SUM