on 05-24-2017 4:18 AM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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. 🙂
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.