Hi Ce Lin,
Basically you are trying to marge two tables without using dashboard.
In this case, you can duplicate data with union.
as a result
AP Test Prep_SM_v10.4.twbx 14.9 KB
Please find the attached.
Kindly make use of below Calc and drag the same to rows (Yes you need to drag Subject First )
School Type Private=
if [School Type]='Private' then 1 else 0 END
School Type Public=
if [School Type]='Public' then 1 else 0 END
Prep Type Free=
if [Prep Type]='Free' then 1 else 0 END
Prep Type Paid=
if [Prep Type]='Paid' then 1 else 0 END
Just drag one by one to get the required VIEW.
The Slogger Blogger at www.tableauinfo.com
AP Test Prep_v10.4.twbx 31.0 KB
Why is that that IF max([Code - Prep Type]) = 1 THEN COUNT([Student Name]) ELSE 0 END doesn't work?
Is this still possible if you used database connections?