Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody.
Totally can't understand whats going on - i have 2 source tables in doc - first is "sales", second - "ware attributes" (vendor, weight etc). Tables connected by ware id. On the sheet i have chart with 2 dimensions - ware_id and vendor and two expressions - sales and total sales. Total sales expression contains "{1} total". Problem is when i add "{1} total" to expression - some wares are duplicated and shown both with vendor and without vendor (vendor is null). If i delete "{1} total" everything is ok - every wares have vendors and aren't duplicated. Looks like "{1} total" make some problems with tables connection. Where is problem?
Thanx for helping and sorry for poor English)
Try checking "Suppress Null Values" for the Vendor dimension.