BookmarkSubscribeRSS Feed
Djones4822
Obsidian | Level 7

Hi all, I'm fairly sure that what I want isn't inherently possible, but I'm trying to determine a work around.

 

I have row level transactional data that is updated multiple times per day. There is a certain set of information our administrators have specifically asked for, that are each aggregations at different levels.

 

The cross tab ideally would have the programs as headers, and thebn each row would be an aggregation level, such as:

 

 

                                            Program 1     |     Program 2     |     Program 3 

Total Outstanding Bal     |         

Num Orders                    |

 

Avg Order Bal                 |

Num Customers             |

Avg Bal per Customer    |

 

 

I can't for the life of me figure out how to use the row level data to achieve that. I've thought about producing a table in the backend that simply has 3 columns like this:

 

Program |              Detail             | Value

------------------------------------------------------

'pgm_x'   | 'Outstanding Balance' | XXXX

 

But that seems unnecessary. I've tried to use multiple cross tabs (one for each aggregation level), but since you can't hide the headers it looks pretty bad.

 

Does anyone have a suggestion to achieve this? I've tried searching but I haven't been able to find what I'm looking for.

1 REPLY 1
FredrikE
Rhodochrosite | Level 12

Is it not possible to use a calculated object that get the value that you want as rows and then a calculated meassure with the actual value?

 

Can you post some sample data?

 

BR

Fredrik

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

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
  • 1 reply
  • 961 views
  • 0 likes
  • 2 in conversation