W
Walmondo Kelly
I have two fields. One field is a summary query for the other field and it
sums the totals for the brands listed in the first field. If I set the
criteria for the brands field so that the first criteria is the leading brand
and the second or line is the second leading brand-what formula would I use
so that the third result would display the total sums of all brands. I want
to have a pivotchart with columns that shows the sum of the first leading
brand in the first column, the second leading brand in the second column and
the sum of all brands in the third column.
sums the totals for the brands listed in the first field. If I set the
criteria for the brands field so that the first criteria is the leading brand
and the second or line is the second leading brand-what formula would I use
so that the third result would display the total sums of all brands. I want
to have a pivotchart with columns that shows the sum of the first leading
brand in the first column, the second leading brand in the second column and
the sum of all brands in the third column.