Forum Discussion
TTP individual values display
Hello - what is happening when you select p10 in the slicer? Is the table visual not changing? What does your data model look like? Is all of your data in one table or do you have multiple tables related to each other? For the values appearing in column D, how are they being created - did you add the column to the values and choose sum as the aggregation or did you create a separate measure and use that in the table visual?
hello, as im putting slicer as p10 it shows the sum of values of column D for p10 across all the rows i.e 449980 in this case across all the region. i want it to show the value as it is and total at the end
Without additional information, I would guess that you might have p10 coming from a dimension table and the sum as a measure from a data/fact table, but in your slicer you are using p10 from the data/fact table. If this is not the case, in order to better assist you...
What does your data model look like? Is all of your data in one table or do you have multiple tables related to each other? For the values appearing in column D, how are they being created - did you add the column to the values and choose sum as the aggregation or did you create a separate measure and use that in the table visual? Please provide screensnips of your data model view that shows the tables and the relationships and show the field/measure used for the sum and the table/field used in the slicer.