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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 621 views
  • 1 like
  • 2 in conversation