It will be more helpful If you share some sample data.
I have a calculated field suppose test and is aggregated filed
when i turn on grand total.
it shows wrong value when export in csv
Can you share the sample workbook of your viz? Else share the crosstab data in excel format with your expected results.
thats not a issue but problem here is if i will share you csv and you will try to do calculation it will be correct.
problem here is only aggregated filed not showing total using sum option available there is automatic and hide
1 of 1 people found this helpful
You can refer this link If you're having problem with grand totals
Hope this help
You can share at least the screen shots If possible.
when you turn on grand totals, the initial values are computing using the current aggregation for the fields in the view. In this case, totals are based on the underlying data rather than the data in the view.
For example, if you are totaling the SUM(Profit) for several products, the grand total will be the sum of the sums of profit. For aggregations such as SUM, you can easily verify the grand total because a summation of a group of sums is still a summation. However, be aware that your results may be unexpected when using other aggregations, especially custom aggregations
can we make it to the view
or what other way we can proceed
Calculation Description Sum Shows the sum of the values shown in the row or column. Average Shows the average of the values shown in the row or column. Median Shows the median for the values shown in the row or column. Count;
Shows how many values or distinct values are displayed in the rows and columns in the view. Minimum Shows the minimum value shown in the row or column. Maximum Shows the maximum value shown in the row or column. Percentile Shows the average percentile for all values shown in the row or column. Standard Deviation The grand total using standard deviation is the standard deviation of the values shown in the row or column. Variance The grand total using variance is not the variance of the rows and columns in which they reside but rather of the underlying data behind the row or column.
IF ATTR([No_])>='511503' and ATTR([No_])<='511523'
ELSEIF ATTR([No_])='511524' THEN ZN([Calibreted Value])
ELSEIF ATTR([No_])>='511525' and ATTR([No_])<='511552' THEN 0
ELSE ZN([Calibreted Value])
its not giving the desired output
What is the desired output for it?
You are using attribute function :“It returns a value if it is unique, else it returns *.”