Forum Discussion
gvg
Post Prodigy
7 years agoShow same column as two in the table without summarizing
Hi folks, How do I show same table column as two columns with different filtering in the table visual? For example if I have positive amounts for income, and negative amounts for expense in the same...
Anonymous
7 years agoNot applicable
Then add a calculated column use add column (using conditional column) in edit queries.
gvg
Post Prodigy
7 years agoAnonymous , no other way to do it? It is expensive to add column to a multimillion row table.
- Anonymous7 years agoNot applicable
You can either add a column(Storage expensive) or create a measure suggested above(computation expensive), thats a trade-off you need to check/test and select
- gvg7 years ago
Post Prodigy
Well, I think if there is no easy way to do what I need (with no summarization), I am probably better off making two separate table visuals.