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