1 of 1 people found this helpful
Please see an example below :
ProfitRatio = SUM([Profit])/SUM([Sales]). Now when you export out the data with calculations, ProfitRatio field will no more be holding any formula.
So, we will not get the required values with exported data.
For addition, subtraction etc. Writing Calculated fields and exporting data works. i.e. Sum(Profit) + Sum(Margin).
Hope this helps
It will be easier, if you post a workbook. Screen shots of what you have and what you expect, would also go a long way.
Thanks Shripal and Allen for the reply.
Apologies..!! cant share the workbook due to confidential issues.
Here are the screenshots.
Previous:act-fct is a calculation(SUM([Turnover CY]) - SUM([expectFCT]) and is shown in tableau view as AGG(act-fct)
Present:Now to avoid calculations and overload,calculations are moved to sematic layer(as columns) . Now those col's are coming as measures and
bought to tableau view,
It is going as SUM(act-fct)
How can I get the accurate value of previous AGG(act-fct)