Filtering Data

[Anonymous]

I plan to create a report that will have ~8 filters.   It is possible the values that are displayed will automatically recalculate based on the filtered results?   For example, my data table might look like this:

RED   10    25%

RED   10    25%

BLUE  5     10%

BLUE  10    60%

If I filter on RED, the end result will display RED 20 50%

If I filter on BLUE, the end result will display BLUE 15 70%

[Anonymous]

Hi @Anonymous

  If we name your columns as A,B,C, create measures as SUM([B]),SUM([C]) . Then place A, SUM([B]), SUM([C])  in the report.

Looks straight forward, am i missing something here? If the requirement is osmething else, please explain,

Thanks

Raj

[Anonymous]

I tried that and here is the result.   I was hoping the Measure column would have summed the Count column and display one line

[Anonymous · Accepted solution]

Measure groups the dimensional values and aggregate the values to the same level. Means, Measure will return one value if all other columns values are same . In your example below, you need to take out the count column, % column to get single row.

Thanks
Raj

[Anonymous]

Thank you.   That worked!