Hi all,
My data is not acting right. I have pasted a screenshot of two tables that I made in tableau of the sales in the different markets in the U.S. I blacked out the market names, for obvious reason. The first table is made with state code grouped, which is a grouping of the different states that I grouped together on a map in tableau to manually create the different regional market levels in the United States. The second one is based on a dimension representing the different markets that i had in my data. The second table is accurate; and the first table based on state code(grouped) is not accurate.
I used fixed LODs to do the calculations for the first table:
{FIXED [State Code (group)] : sum(iif([Report Vendor]= "DF",
[Case Equivalents LY], 0))}
{FIXED [State Code (group)] : sum(iif([Report Vendor]= "DF",
[Case Equivalents LY], 0))}
And for the second table I used these LOD expressions for the two columns:
{FIXED [Company Market Level] : sum(iif([Report Vendor]= "DF",
[Case Equivalents TY], 0))}
{FIXED [Company Market Level] : sum(iif([Report Vendor]= "DF",
[Case Equivalents LY], 0))}
The grand totals match up on both tables, but the totals for the different markets don't match up. I think it maybe due to the fact that some states correspond to more than one market in my data, which is something I have to work with, and when I grouped the states together for the first table, and then used this grouping in the fixed LOD, tableau may be moving some numbers around. I would really like to be able to use the custom territory map that i created by manually grouping the states, so if anybody could help me fix this issue, I would really appreciate it. Thanks.
regards,
Sajeel Adnan
posted a file.
