Two Tables with Current Selection with only one selection different

[cristian_av]

Hi

I need two tables to show data from current selection and the same table. The first table has to show the values from the "Real" income and the second one from the budget income.

I need to show the data "As Is", i.e. not the sum or something like.

RealBudget	Amount	Date	Center
Real	5000	01-02-2016	123
Real	500	02-02-2016	125
Real	300	03-02-2016	123
Real	200	04-02-2016	126
Budget	6000	01-02-2016	123
Budget	600	02-02-2016	125
Budget	350	03-02-2016	123
Budget	250	04-02-2016	126

Any idea how to do this? I actually can show the info but in the same table.. but how can I split the data in two tables Real/Budget?

Thanks!!

[sunny_talwar]

May be using set analysis within a straight table? Which object are you trying to this today?

[girirajsinh · Accepted solution]

You may do something like this in straight table

and hide the expression

[cristian_av]

It worked! Thanks!

[sarafamiglietti]

Hello,

Please find attached a way to solve the problem.

You just have to create 2 graph "Table".

Put Realbudget, Date and Center as Dimension and in the expression you have to use a "if".

-> For real : if(RealBudget = 'Real',sum(Amount))

-> For budget : if(RealBudget = 'Budget',sum(Amount))

Regards

Sara