Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Month Measure Segmentation

Reply
Occasional Contributor
Posts: 9

Month Measure Segmentation

Hi,

I Have this problem with SAS Visual Analytics 7.2 in a crosstab

 

Situation:

CategoryGroup MonthJanuaryJanuaryFebruaryFebruary
CategoryMonth GroupContactSellContactSell
MeasureContact Group110472
Measure Sell Group215583

 

 

Situation Desired

CategoryGroup MonthContactContactSellSell
CategoryMonth GroupJanuaryFebruaryJanuaryFebruary
MeasureContact Group110742
Measure Sell Group215853
Occasional Contributor
Posts: 10

Re: Month Measure Segmentation

What does your source table look like?

Would it be sufficient to remove group as column and re-add it above the period?

Occasional Contributor
Posts: 9

Re: Month Measure Segmentation

I tried to explicate the problem in attached file

Thank you

 

Attachment
SAS Super FREQ
Posts: 275

Re: Month Measure Segmentation

Hello,

 

It looks like you want the columns in a crosstab to be grouped by the measures rather than the categories. I don't think this is possible.

 

If you move MONTH to the row axis (no category assigned to the column axis), the result might be closer to what you want.

 

Another possibility might be to create a separate crosstab for each measure.

 

I hope that helps,

Sam

Occasional Contributor
Posts: 9

Re: Month Measure Segmentation

Thank you very much but unfortunately not good

Occasional Contributor
Posts: 10

Re: Month Measure Segmentation

I have to agree with Sam.

 

In a single cross-tab. This does not seem possible. It is required to use measurements on the lower part.

 

I will propably get yelled at for this, but you could split up your rows between sell and cross.

Columns:

- Category: Group

- Category: Month

- Category: Type (Contact/Sell)

- Measure: Value

 

With that you could create a crosstab that looks quite like you want it, but only has the 'value' as measure and the Month and Type as Columns.

 

I am very unsatisfied with such duck-tape solutions, but it depends on how bad you need it to actually look you stated.

Hope this helps push you into a somewhat acceptable solution.

 

Regards,

Roy

Occasional Contributor
Posts: 9

Re: Month Measure Segmentation

not exactly what I needed but still is a good idea
thanks a lot

Lorenzo

Occasional Contributor
Posts: 10

Re: Month Measure Segmentation

Could you mark answers as helpful or solved if you think that is what they are?

This helps others pick out the messages easier.

Post a Question
Discussion Stats
  • 7 replies
  • 427 views
  • 1 like
  • 3 in conversation