I created a field (Change Employment - the difference between 2 fields),
I created a calculated dimension (Industry classification - 4 categories based on 2 measures),
I want to sum Change Employment for each of the classifications and list as a set of BANs.
I would think that I could place the Industry Classification variable/pill on the column shelf - that does nothing. I tried using a calculated field, using FIXED (LOD), but I can't mix aggregate and non-aggregate...
Any suggestions on displaying total change by each of the categories on one worksheet?
1 件の回答
so, i added "NAICS Code" to the display, because it is each NAICS that is being classified. however, I just want the number, not bars (that are the sum of disaggregated parts).
