Can I create a dimension based on measures only?

[Anonymous]

I have:

January Revenue

February Revenue

March Revenue and all the way to December Revenue. So, twelve measures. However, I don't have a dimension with month, so that I could have created a chart to show my measures by month.

What are my options?

Thanks in advance.

[effinty2112]

Hi Pawel,

You have one dimension, month, of which you have twelve values, Jan to Dec. You have one measure, the sum of revenues. The way your data looks right now may it not resemble what I say but I'm sure we can knock it into shape and then get a chart.

Can you post your data and we'll have a go?

Cheers

[sunny_talwar]

Have you considered using CrossTable() load to fix your data in the back end? It can save you a lot of time when creating charts such as the one you just described.

[Anonymous]

Hi Andrew,

I do have dimension month, however it is showing only one month -> october.

What I did, I pulled revenue by month from one source. So, I have twelve separate measures. Each of them showing revenue for each month. In order to create a chart, i need to assign/create
"January" to Jan-14 Rev and etc. And then group this newly created "Months" under single dimension, which i may use in chart.

[effinty2112]

Hi Pavel,

I made an excel file from the image of your data. It's the same as the table you showed only with the two leftmost columns and the top row removed.

This is the script created in the qvw by stepping through the file wizard and transposing the table. I hand edited the first line to extract the month name.

Data:

LOAD Left(@1,3) as Month,

     @2 as Revenue

FROM

Data.xlsx

(ooxml, no labels, table is Sheet1, filters(

Transpose()

));

I thoroughly recommend you using the File Wizard with as many different data files as you can find. With practice you'll get the hang of it.

Hope this is what you are after.

Regards