variable/help to format report

[former_member557046]

Hello experts,

I have a created report that I am getting data for. I am having difficulties in displaying it the way I need.

Model           Features            Info/Result

BMW              color

Mercedes        sunroof

Lexus              manual

Infiniti              GPS

                      engine size

Each car will have each of those features and consequently a varying result for each.

I would like it to display in a crosstab like this, with the info/result in the middle.

                     BMW       Mercedes    Lexus        Infiniti

color

sunroof

manual

GPS

engine size

Can it be done? I tried without any variables and it displays wrong data.(data for 1 car repeats and repeats)

Thanks for any help that one may offer.

Chuck W.

[Former Member]

Hi chuck,

Your data has multiple records for each combination of Model and Feature. For example Benz can be having multiple colors so you will be getting 2 records with the combination of Benz and color. Similar scenario will be applicable in other combinations.

What you can do is, in your cross tab create a break on the Feature object and remove the break footer and select the option to display the value only once in the center.

This will avoid showing duplicate feature names for each model and at the same time displays all the values of a particular feature model combination.

If this doesnot work out please share the screenshot of your current cross tab and expected results, so that we can suggest you better

[Former Member]

Hello Chuck,

So basically what I noticed from your data that you have a Many to Many relationship with Model and Feature. means a model can be automatic or manual and unless we have a fixed set of features that can be answered as Yes or No it would be difficult to structure your data in a Cross Tab.

Since Cross Tab requires a measure Object that needs to be shown against different Dimension. However, if it is not possible to structure the data I suggest you can go for an alternate design by showing the Models in a group with each group displaying the available Features of Model.

e.g.

BMW

Model Feature

BMW  Automatic

BMW  Black

BMW  GPS

Lexus

Model Feature

BMW  Manual

BMW  Red

BMW  Sun Roof

and so on

Regards

Niraj

[amitrathi239]

what are the values in the Info/result object? number or string? Info/result is measure or dimension object?

If it is dimension the create measure variable and try.

[former_member557046]

hi,

most features give result object as string. engine size result object is number.

info/result object is dimension I believe.

what kind of variable would you create?

I tried v_result = [ info_result] forEach [Model] which didnt do anything in the crosstab.

Do I need to create a variable for each/every cell in the crosstab to get it to display?

this will be a scheduled report and the models change day to day.

thanks

[amitrathi239]

try to create info result object as measure variable and try.

ideally you need a measure object/variable with number data type in crosstab column to get the correct result.