Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Editing of 'totals' & 'subtotals'

Reply
Occasional Contributor
Posts: 13

Editing of 'totals' & 'subtotals'

Hi,

Can we edit “Totals” and “Subtotals” in SAS VA?

For example:

Calculation (aggregated measure) for Column 2 below is:

Sum[by group](Column1) / Sum[by group](Column 3)

Column 1 Column 2 Column 3

10,000 500 20

20,000 1000 20

Subtotal

Column 1 Column 2 Column 3

30,000 750 40

Thanks,

Sarthak

  I would like to change the Subtotal for Column 2 to give me 500 + 1000 = 1500 instead of 30,000 / 40 = 750.

Occasional Contributor
Posts: 5

Re: Editing of 'totals' & 'subtotals'

I am also wondering the same Sarthak89.

Is it possible to edit default column totals/subtotals for a crosstab object?

Frequent Learner
Posts: 1

Re: Editing of 'totals' & 'subtotals'

did you sort this out..?

Post a Question
Discussion Stats
  • 2 replies
  • 279 views
  • 0 likes
  • 3 in conversation