Set Analysis - Budget vs Actuals

[lightsection]

HeadClient	Client	Fact_Type	Revenue	Budget
ABC Corp	Orange	CRM	1000	NULL
ABC Corp	Orange	Budget	NULL	2000

In the above table, I have 3 dimensions and 2 facts (Revenue & Budget).

Using Set Analysis, in a chart / table, how do we show the above 2 rows as a single row, instead of 2 separate rows ?

[kaushiknsolanki · Accepted solution]

Hi,

As you can see your data, its a Fact_Type is the field which distinguishes the Revenue and Budget, So if you remove that field from dimension then you will see single record.

Regards,

Kaushik Solanki