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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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