how to show total
I have a data as below, I need to show a max of all numbers throughout all the columns,
how can I achieve this incorta
Hi thank you for your reply :
the above one is a sample data, I have a requirement like this
I have a month start column, where I want to display the only max month of the data
Fisical Month Month Start data Nov-17 11/1/2017 4267 Dec-17 12/1/2017 3290 Jan-18 1/1/2018 4762 Feb-18 2/1/2018 5108 Mar-18 3/1/2018 4883 Apr-18 4/1/2018 4786 May-18 5/1/2018 4710 Jun-18 6/1/2018 4349 Jul-18 7/1/2018 4103 Aug-18 8/1/2018 4556 Sep-18 9/1/2018 4649 Oct-18 10/1/2018 4132 Nov-18 11/1/2018 4064 Dec-18 12/1/2018 3567
but I want to display the max month data in the text box as:: "3567" which is December month by default and it should change based on the filters
but I am unable to get this requirement :
I am getting an error as an invalid formula
I used the same as what you have suggested but max is displaying somewhere in between
formula i used : if(test.Month_Start=max(test.Month_Start,groupBy()),sum(data),0)
Fisical Month Month Start Max month if(test.Month_Start=max(test.Month_Start,groupBy()),sum(data),0) data Nov-17 11/1/2017 INVALID FORMULA 4267.00 Dec-17 12/1/2017 INVALID FORMULA 3290.00 Jan-18 1/1/2018 INVALID FORMULA 4762.00 Feb-18 2/1/2018 INVALID FORMULA 5108.00 Mar-18 3/1/2018 12/1/2018 INVALID FORMULA 4883.00 Apr-18 4/1/2018 INVALID FORMULA 4786.00 May-18 5/1/2018 INVALID FORMULA 4710.00 Jun-18 6/1/2018 INVALID FORMULA 4349.00 Jul-18 7/1/2018 INVALID FORMULA 4103.00 Aug-18 8/1/2018 INVALID FORMULA 4556.00 Sep-18 9/1/2018 INVALID FORMULA 4649.00 Oct-18 10/1/2018 INVALID FORMULA 4132.00 Nov-18 11/1/2018 INVALID FORMULA 4064.00 Dec-18 12/1/2018 INVALID FORMULA 3567.00Reply
venkatRao - Hi Venkat, we have a planned feature on our near-term roadmap which will support this ask. In the interim, there are a few other ways that this can be modeled in Incorta - i.e. Incorta table. I believe you are meeting with Anurag Malik this week. He can show you the alternate approach.Reply
I just tried in this way .
create a schema and add table to it.
create a formula column at table level in schema
now explore data by table insight and sort all the data by dragging the above derived_col (desc or asc as per the need)
restrict the page size to 1 in settings.
note: we are able to drag the formula column to sort option in table insight only when we create that formula at table level in schema only.Reply