topic Re: Cross table with two hierarchies in SAS Visual Analytics

Cross table with two hierarchies

hkara — Thu, 24 Sep 2020 14:17:30 GMT

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

Re: Cross table with two hierarchies

PetriRoine — Fri, 25 Sep 2020 09:35:06 GMT

Hello @hkara

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

Best regards,

Petri

Re: Cross table with two hierarchies

hkara — Fri, 25 Sep 2020 10:53:03 GMT

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?

Re: Cross table with two hierarchies

PetriRoine — Mon, 28 Sep 2020 05:54:08 GMT

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

Best regards,

Petri