-
1. Re: Excluding values in a text table
swaroop.gantela Nov 30, 2018 6:00 PM (in response to Jordan Shatila)Jordan,
It might be something in the Table Calculation settings for [% of Total Net Sales].
Would be grateful if you would post screenshots of the settings for that for each workbook.
-
2. Re: Excluding values in a text table
Ritesh Bisht Nov 30, 2018 7:11 PM (in response to Jordan Shatila)Wonder if you have something in LOD section which is giving you the above values, can you post the workbook?
-
3. Re: Excluding values in a text table
Jordan Shatila Dec 1, 2018 12:50 AM (in response to swaroop.gantela) -
4. Re: Excluding values in a text table
Chris McClellanDec 1, 2018 1:45 AM (in response to Jordan Shatila)
Is Level 1 Display a calculated field ?
-
5. Re: Excluding values in a text table
Jordan Shatila Dec 2, 2018 8:41 PM (in response to Chris McClellan) -
6. Re: Excluding values in a text table
Jordan Shatila Dec 2, 2018 8:41 PM (in response to Ritesh Bisht)Hi Ritesh,
unfortunately I cannot post the workbook due to sensitivity of data... but both workbooks are built on the same data source with all of the same equations for all calculated fields... the LOD calculation for % of Total Net Sales for both workbooks is:
SUM([NetSales]) / TOTAL(SUM([NetSales]))
-
7. Re: Excluding values in a text table
swaroop.gantela Dec 3, 2018 6:32 PM (in response to Jordan Shatila)Jordan,
From the Top Menu, is Analysis>Aggregate Measures selected in both workbooks?
Another thing to try would be to use a Level of Detail calculation instead of a Table Calculation:
{ FIXED [Level 1 Display],[Calendar Date]:SUM([Net Sales])}
/
{ FIXED [Level 1 Display]:SUM([Net Sales])}
If neither help, I have posted a mock dataset;
would be grateful if you would modify it to more closely match the structure of yours.
-
289167hide.xlsx 8.0 KB
-