Skip to Content
0

How to create new dataset including my calculation?

May 24, 2017 at 03:18 AM

102

avatar image
Former Member

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?

gg.png (50.9 kB)
gg1.png (38.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

avatar image
Former Member May 24, 2017 at 04:00 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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?

0
avatar image
Former Member May 24, 2017 at 05:04 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 25, 2017 at 01:53 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 25, 2017 at 02:50 AM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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. :)

gg11.png (60.1 kB)
gg11.png (60.1 kB)
0
Former Member

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?

0
Former Member

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.

0