In the pivot, I have two columns with numeric values. I would like to create third column with ratio of those two compute columns.
Is it possible? I do not want to add to the search in the data model because then I cannot use other attributes.
Data Column1 Column2 Column3
01-01-2015 100 200 0.5
02-02- 2015 200 100 2
Add a calculated field using eval expression to your data model.
App-> pivot->choose datamodel-> Edit->disable acceleration(if enabled) -> Edit --> Add attribute --> Choose Eval ( enter below eval condition & Preview, submit)
And also you can find more information for adding calculated fields here.