12 Replies Latest reply on Jul 11, 2016 4:28 AM by Tharashasank Davuluru

# How to calculate aggregate column grand total

How to calculate aggregate column grand total?

• ###### 1. Re: How to calculate aggregate column grand total

It will be more helpful If you share some sample data.

Mahfooj

• ###### 2. Re: How to calculate aggregate column grand total

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

• ###### 3. Re: How to calculate aggregate column grand total

Can you share the sample workbook of your viz? Else share the crosstab data in excel format with your expected results.

• ###### 4. Re: How to calculate aggregate column grand total

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

• ###### 5. Re: How to calculate aggregate column grand total

You can refer this link If you're having problem with grand totals

Hope this help

• ###### 6. Re: How to calculate aggregate column grand total

You can share at least the screen shots If possible.

• ###### 7. Re: How to calculate aggregate column grand total

Hi,

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

• ###### 8. Re: How to calculate aggregate column grand total

can we make it to the view

or what other way we can proceed

• ###### 9. Re: How to calculate aggregate column grand total

Hi,

Aggregation

Calculation Description
SumShows the sum of the values shown in the row or column.
AverageShows 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;
Count Distinct
Shows how many values or distinct values are displayed in the rows and columns in the view.
MinimumShows the minimum value shown in the row or column.
MaximumShows the maximum value shown in the row or column.
PercentileShows the average percentile for all values shown in the row or column.
Standard DeviationThe grand total using standard deviation is the standard deviation of the values shown in the row or column.
VarianceThe 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.
• ###### 10. Re: How to calculate aggregate column grand total

IF ATTR([No_])>='511503' and ATTR([No_])<='511523'

THEN 0

ELSEIF  ATTR([No_])='511524' THEN ZN([Calibreted Value])

ELSEIF  ATTR([No_])>='511525' and ATTR([No_])<='511552' THEN 0

ELSE ZN([Calibreted Value])

END

its not giving the desired output

• ###### 11. Re: How to calculate aggregate column grand total

Hi,

• ###### 12. Re: How to calculate aggregate column grand total

Hi,

What is the desired output for it?

You are using attribute  function :“It returns a value if it is unique, else it returns *.”