This content has been marked as final.
Show 1 reply

1. Re: Creating the equivalent of a Venn diagram?
Joe Mako Mar 19, 2011 12:13 PM (in response to Ramon Felciano)How about something like the attached?
I used a calculated field:
CASE SUM( CASE [Category] WHEN "A" THEN 100 WHEN "B" THEN 010 WHEN "C" THEN 001 END) WHEN 111 THEN "ABC" WHEN 110 THEN "AB_" WHEN 011 THEN "_BC" WHEN 101 THEN "A_C" WHEN 100 THEN "A__" WHEN 010 THEN "_B_" WHEN 001 THEN "__C" END
To kind of use flags to determine the combination of Categories, and then with the ID field on the Level of detail shelf, I could use a Reference Line to sum the distinct count of IDs per grouping.
Does this work for your situation? If not, can you provide data that represents your situation?

groupings.twbx 11.7 KB
