Is it possible to created Facts/Measure in Logical SQL
Summary
Is it possible to created Facts/Measure in Logical SQLContent
Hi all,
I need to pivot and show percentage of a column but seems like it is not possible to create a fact from an existing dimension within Logical SQL.
I initially added person number as measure in the pivot table and used count distinct aggregate rule. As we know person number is a dimension in itself, I want person number to be a fact so that I can use the feature show data as under the measure to show data as percentage of row.
When I try to update the formula for person number to count distinct person number, it returns an error saying it needs a group by which is understandable.
0