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

Hi,

just wanted to know how place two hierarchies in a single cross table.

e.g. One on product level and one on time level like

product_group -> category -> item

year -> month -> day

thanks for your help

 

1 ACCEPTED SOLUTION

Accepted Solutions
PetriRoine
Pyrite | Level 9

Hello @hkara 

 

Below is example how to place two hierarchies in a single crosstab.

Capture.PNG

 

Best regards,

Petri

View solution in original post

3 REPLIES 3
PetriRoine
Pyrite | Level 9

Hello @hkara 

 

Below is example how to place two hierarchies in a single crosstab.

Capture.PNG

 

Best regards,

Petri

hkara
Calcite | Level 5
Hi Petri, thanks for your help,
according to your example, I'm assuming that Year... and Group... hierarchies cannot be placed both onto either columns or rows?
PetriRoine
Pyrite | Level 9

You are correct - currently a hierarchy cannot be assigned to a role with another data item or hierarchy.

 

Best regards,

Petri

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 683 views
  • 1 like
  • 2 in conversation