I did a little bit of searching on this and I still haven't found true answer. I've implemented workarounds but I'm just checking if there's an easier way. My source data looks as follows:
Customers:
Name
John
Debbie
Michael
Paul
Laura
Peter
Eric
Lisa
Monthly Summary
Name
# of Item
John
2
Paul
5
Peter
2
Eric
8
Lisa
9
Peter
5
Lisa
2
Lisa
7
John
2
Peter
3
LIsa
9
Desired Straight Table
Desired Straight Table
Name
Total Items
John
4
Debbie
0
Michael
0
Paul
5
Laura
0
Peter
10
Eric
8
Lisa
27
I'm aware of the 'Show All Values' option in the Dimensions tab and the 'Suppress Missing' and 'Suppress Zero-Values' in the Presentation tab. Those options still doesn't give my desired straight table shown above. My workaround is I've added '0' as a dummy value for all customers but I want to know if there's a simpler way.
Also, how can I have a straight table of names that are NOT in the Month Summary?
hmmm... thanks for your response! Looks like that does work. I have another tool with sensitive data I'm not able to share. I tried to provide an basic example but I'm not getting the results that I want. I'm actually doing a pivot table.. could that be it?
If I change it to a pivot table, it also still shows the zeroes (see attached), so I don't think that's it. It's hard to say what the problem is without seeing your actual report. You may want to try reading Preparing examples for Upload - Reduction and Data Scrambling to see if there is anything you can do to get an example report up here.
I think I know what the issue is. I'm have a set analysis in my pivot table which I believe is filtering out the zeros. As a workaround, I have inline table with dummy values to meet the criteria of the set analysis. How can I show the zeros AND the set analysis without dummy data?
