Forum Discussion

SabineOussi's avatar
SabineOussi
Skilled Sharer
10 years ago
Solved

Total Count with Selection

Hello,   I'm trying to create a table of customers, their total shipment count and an additional column to show the count of how many shipments were made with a certain priority. Priority is being ...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    SabineOussi,

     

    I could found a workaround for your issue, It's not pretty nice looking, but I guess it works :)

     

    I assume that you have a reference table with your customers stored in.

    I've created a new column based on a formula :

     

    The formula count the number of ship (here it's a sum because I didn't create all the record),

    And now, when you used if you don't select any flag type, both of the columns are the same :

     

    But as soon as you select a flag type, the "ship by customer" column stay the same when the other column is updated :

     

    Hope it help you

     

    Sébastien

Anonymous's avatar
Anonymous
Not applicable
10 years ago

SabineOussi,

 

I could found a workaround for your issue, It's not pretty nice looking, but I guess it works :)

 

I assume that you have a reference table with your customers stored in.

I've created a new column based on a formula :

 

The formula count the number of ship (here it's a sum because I didn't create all the record),

And now, when you used if you don't select any flag type, both of the columns are the same :

 

But as soon as you select a flag type, the "ship by customer" column stay the same when the other column is updated :

 

Hope it help you

 

Sébastien

SabineOussi's avatar
SabineOussi
Skilled Sharer
10 years ago

Hi Anonymous,

 

The new column does its job on a condition that I modify the slicer interaction and make it None to my table in question. Since I'm only interested in one value for that particular page, the filtering will be unecessary.

 

Thank you!