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
Forum Discussion
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.
