BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
rushir_sysware
Calcite | Level 5

Hi there,

I am trying to figure out how does a Row Total work in SAS Visual Analytic 7.0 For example if I have a Column A and Column B, When I select Row Total I would expect it to add another column which adds Column A + Column B


When I click on Row Totals nothing is changing on the Exploration and Reports. Do i need to setup something else for this to work?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
avvy
Quartz | Level 8

Hi,

Please check for the categories that you have assigned to column field. The row total works once you assign it in the cross tab.

If you want to have totals with only rows assigned to the cross tab, you can create a calculated item, lets say "Total" with the measures that you have assigned to cross tab and then simply drag and drop the "Totals" in the cross tab.

Hope this helps.

Regards,

Abhishek

View solution in original post

3 REPLIES 3
avvy
Quartz | Level 8

Hi,

Please check for the categories that you have assigned to column field. The row total works once you assign it in the cross tab.

If you want to have totals with only rows assigned to the cross tab, you can create a calculated item, lets say "Total" with the measures that you have assigned to cross tab and then simply drag and drop the "Totals" in the cross tab.

Hope this helps.

Regards,

Abhishek

saspert
Pyrite | Level 9

there are subtle differences between a crosstab and a list table. try both tables and see if it is confined to 1 type. if you want the row totals, you can also try adding a calculated item (A+B). That option wont work for you?

jplarios
Quartz | Level 8

Hello,

Adding to the original question; if I were to do the A+B; in our case a A-B, our problem would be that it would add the A-B under both A and B. Any workarounds from SAS VA - not from the data if possible- that someone can help?

Also, I noticed that if we had a year and dropped the difference from previous parallel period; besides behaving as it did on the calculated A-B as mentioned above, it will also do it for the minimum time period. For example, If I had 3 years of data and filtered to get only the previous 2, it would also add the previous parallel period measure under the earliest year and display a null since the previous year for the earliest year is filtered. Shouldn't just not show? or can we have the parallel period on its own column once?

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 4803 views
  • 3 likes
  • 4 in conversation