-
Input Calculation
Hello, Is there a way to have a user interact with a table visualization whereby they enter a value into a field and have it calculate another value? For instance, we have an interest rate in one column, and we are looking to have the capability to enter a value in a 2nd column to have it return a calculation in a 3rd…
-
Beast Mode is Inaccurate
I have 2 Beast Modes that are returning inaccurate results. If I place each Beast Mode in a separate column in my table, they both return their respective values of 01 or 02 for every line even though they are opposite and even though not every line meets either criterion. Any suggestions? Thanks! CASE WHEN GL Group Code…
-
List 2 Time Periods in a Table
Hello, I need to list 3 categories for 2 different time periods in a table. See attached sample. I cannot find any instructions on how to accomplish that. Can anyone point me in the right direction or share their knowledge? Thanks!
-
Add a Blank Column
Hello, Is there a way to add a blank column as a sort of place holder in a Table Chart Visualization? Thanks!
-
Subtotal Within a Subtotal
Hello. I am trying to subtotal within a subtotal. I have both of my columns in the "A" and "B" columns, and they are in Sorting in the order in which to subtotal. I have 'Show Subtotals' checked. However, it is only subtotaling the 1st column. Thanks!
-
How do you suppress individual line items?
I only want to see the subtotals of a grouping. How do I suppress the individual line items in a table chart? Thanks!
-
Filtering on Calculated Values
I have a Beast Mode that is calculating the difference between 2 columns. I need a filter that will give me all of the values that are $10k and above and all values that are -$10k and below. I assume I need to create a 'When' Beast Mode that includes both of the filters, but I am getting a Syntax error. I am thinking maybe…
