cancel
Showing results for 
Search instead for 
Did you mean: 

How to create new dataset including my calculation?

Former Member
0 Kudos

Hi there,

I have created a custom calculation in the crosstab which called "Final price" in the measure panel. I want to add "Final price" to the Rows panel but it did not work. So I create new dataset, I think the "Final price" will show in the dataset as a dimension. After I create new dataset, there is no "Final price " value... Anyone can tell me the way how to add "final price" value to the rows?

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Nate,

If you create a new calculation in the prepare tab, then it will only be there for the current document. If you create a new document then it will disappear as it is only saved with the document, i.e.: it is not a shared variable like you have in Crystal Reports or Webi. If you want it to be there everytime, then add the calculation as a filed in your data source. You can change the type of calculation from a measure to a dimension in the prepare tab.

1) You cannot have just one measure in the rows. You will have to put all of your measures in the rows and put your rows as your columns

2) Convert your formula to a dimension, although this may cause some data issues with summing etc.

What are you trying to achieve or better said, what do you want the end result to look like?

Thanks,
Kevin

Former Member
0 Kudos

Hi Kevin,

Thanks heaps for your reply!

The end of result I want is let "Final Price" to be a row, like the graph I shows below, e.g. I want "Final Price" to replace "EA Price" on the X axis.

The problem is I can not create " Final Price " in the prepare tab. Because I need to use Var(), Avg() function which not provide in the prepare tab. I created "Final Price" which only can be used as measures, I am thinking how to change "Final Price" measure to a dimension, so I could use "Final Price" to my X axis.

Look forward your answer. 🙂

Former Member
0 Kudos

Where does your source data come from, Excel, BW, SQL Server etc? In your original post it shows EA Price as a measure and in your chart it is a dimension... Am I right in assuming that EA Price is a dimension?

Former Member
0 Kudos

My source data comes from Universe. Yes, EA Price is one dimention that I create in my prepare tab, "EA" price use the round() function which provide in the prepare tab, so I could create EA Price. But Final Price have to use var() and avg() which do not exist on the prepare tab.

Former Member
0 Kudos

Hi Nate,

Yes, create the object in the prepare section. I will have a go at this later on at home where I have access to Lumira.

Thanks,
Kevin

Former Member
0 Kudos

Hi Kevin.

Thanks for your quick reply. What do you mean the "previous tab"? Do you mean that I should create "Final Price" in my prepare section?

Former Member
0 Kudos

Hi Nate,

I believe that you should create your calculation on the previous tab, then it will be part of your data set. Unfortunately, I do not currently have access to Lumira so cannot verify this for you.

Thanks,
Kevin

Former Member
0 Kudos

Hi Kevin.

Thanks for your quick reply. What do you mean the "previous tab"? Do you mean that I should create "Final Price" in my prepare section?