Crosstab add column with a difference

Hello, 
 How can I add a column in a crosstab , with the difference of two columns . 
Column 1 = 10 
Column 2 = 30 
Column 3 = 20 
 
Thanks

Find more posts tagged with

Comments

micajblock

Right click on one of the measures and and select 'Add Derived Measure'

cennamoc

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="145313" data-time="1473965695">
<div>
Right click on one of the measures and and select 'Add Derived Measure'
</div>
</blockquote>
 
Hello mblock, Thanks for your answer, But how do I define the operation in the derived measure for the two column.
thanks
 

Hello, Thanks for your answer, But how do I define the operation in

micajblock

In the expression builder for the derived measure select available column bindings. You should see your 2 previous measures.

cennamoc

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="145332" data-time="1474036147">
<div>
In the expression builder for the derived measure select available column bindings. You should see your 2 previous measures.
</div>
</blockquote>
My measures is one (month), parameters report are year , month start , month end.
 
The months selected con be max 2.
 
 In the expression builder i see only one measured
 
thanks.

micajblock

OK, now I understand the requirement. I do not know off the top of my head. Let me investigate.

micajblock

OK, so one way to do this is to
<ol><li>create a total for the crosstab</li>
<li>add an aggregation for first, set visibility to hide</li>
<li>add an aggregation for last, set visibility to hide</li>
<li>Add a data item that is last - first</li>
</ol> 
See attached example using classic models.

cennamoc

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="145357" data-time="1474359965">
<div>
OK, so one way to do this is to
<ol><li>create a total for the crosstab</li>
<li>add an aggregation for first, set visibility to hide</li>
<li>add an aggregation for last, set visibility to hide</li>
<li>Add a data item that is last - first</li>
</ol> 
See attached example using classic models.
</div>
</blockquote>
Hi mblock,
 
Perfect, it works . 
Thank you very much for helping
<blockquote class="ipsBlockquote">
 
<blockquote class="ipsBlockquote">
 
</blockquote>
</blockquote>