Hi @TableauIsBetter, For the cumulative calculation based on selected date, you can refer to the following sample formula: formula = VAR selected = MAX ( NewTable[Date] ) RETURN CALCULATE ( SUM ( Table1[Amount] ), FILTER ( ALLSELECTED ( Table1 ), NOT ( Table1[Condition] ...
I produced this view by exporting the results of the table calculation you made as crosstab and joining the new file with the original data source. It works but it's not practical in a long term. Thank you in advance. Expand Post UpvoteReply Aaron...
returns the sum of all rows values in a numeric column. sum() follows this syntax. select sum( column_name ) from dataset where condition ; developer centers heroku mulesoft tableau commerce cloud lightning design system einstein quip popular resources documentation component library apis...
So if i stand correctly, a ''simple calculated field'' will immediately add a a column in the Tableau Data Engine (view data) and the results are available for every row filtered , but a calculation including a Table function (Lookup, Running, Window) will be calculated only on the windo...
Hi @TableauIsBetter, For the cumulative calculation based on selected date, you can refer to the following sample formula: formula = VAR selected = MAX ( NewTable[Date] ) RETURN CALCULATE ( SUM ( Table1[Amount] ), FILTER ( ALLSELECTED ( Table1 ), NOT ( Table1[Condition] ...
Edited by Tableau Community May 8, 2020 at 6:07 PM hi see the attached it returns this start with this to fix the sales at the cust level then this then this for the % profit and make the viz Jim If this posts assists in resolving the question, please mark it helpful or as the ...
Tableau Community (Tableau) 10 years ago Hi Prashant I'll definately vote for dynamic parameters :-) I think the dynamic parameter thread works for som cases. In my case Ive got two variables. Each variable counts each row that meets a condition in my dynamic paramet...
Edited by Tableau Community May 8, 2020 at 7:38 PM hi use this drag to the marks card and aggregate with AVG when month is in the view you get this when month is not in the view you get this the average of the 3 months Jim If this posts assists in resolvin...
I tried to achieve this with a condition IF but the result is that either it shows the columns B with value 250, C with value 250 and D with 500 or it shows the 4 bars each with value 250 and not the last bar D with value of 500. ...