How to visualize the context of filter function inside calculation

[kyrpav]

I want to do a calculation function and at any point in this calcuation i have a FILTER function

is it possible that i can see the dataSet filtered in comparizon thought to pivot.

So if i have a table with movies categories, movies , cost  and revenue in time

And want to make a pivot with cumulative sum. Using the normal calculation.

calculate(sum(revenue),filter(all(movieTable),category=max(category) && movie=max(movie) && date<=max(date)))

How can i see in table what is placed to calculation?

[Anonymous]

@kyrpav 

This is just sum the revenue grouped by the 3 columns. It is not feasible to display the backend calculation, you may only add relevant columns to a matrix to table visual. However, I am not sure what kind of information you want to display, maybe visually explain your needs.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[kyrpav]

Debugging is my problem not the visual it self. sinse the result may be not ok i want to visualise some how the context of the calculation cause by placing of the visual and select the rows and columns i am difining the contaxt but it seems that the calculation does not identify it exactly. 

So irrelevant of the specific case scenario which i have asked in another topic, in this i want to ask if i can really visualise the context of some calculation, not the result but the  table which was filtered to make the calculation based on selections of fields in a visual

[amitchandak]

@kyrpav . This will give running total for Category, movie, and date.

So you need to have these three columns with required measures  (Matrix or Table)

[kyrpav]

@amitchandak i want to be ablt to see what data are used for the sumerization to understand if something should or not should be included or why something is excluded