Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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