Forum Discussion

mmarquez225's avatar
mmarquez225
Cloud Apps
02-01-2023

Need to filter rows based on value from one column

Hello -  any idea how I can filters row based on the value of only one column?

Example I only want to show rows that have a value ">0" for apple_pay

 

 

5 Replies

Replies have been turned off for this discussion
  • This is a basic feature that excel can do but sisense not, apparently..

    • mmarquez225's avatar
      mmarquez225
      Cloud Apps

      Thanks, mdoria   agree, it's actually a basic thing in any BI tool except for Sisense...

  • Hi Ravid_PaldiTeam , this functionallity can be used only as developer, the viewer should be able to filter pivot tables based on formulas calulated inside the pivot. Example, I want to show unit cost per product in a flexible time period. You will need a pivot table with [unit cost] = total cost/nº units. The viewer should be able to filter the pivot table based on the column [unit cost], or having a filter on the dashboard that can calculate  [unit cost] = total cost/nº units and filter based on it. Currently you only can filter by data that is already on the cube, not data that is being aggregated on the dashboard.

  • Hey Ravid_PaldiTeam, thanks for your help, I'll give more details on the I only want to filter a row based on the conditions value of 1:3 columns. If Columns A doesn't have a value, filter out the row. I still want to show Columns B and C. 

    The values for columns A,B,C is  using a "count(item_name)" function so I can simply use the built-in filter of  "item_name>0"  which tried but doesn't work.

    This would be something we would use in a normal table in sheets where we can filter out rows based on the filter conditions we set in the column.

    thanks in advance for your help