Need to ignore filter and not exclude

[#1]

I have a data set as below:

Region     Value     sum(Value)/Sum(Total(Value))

A     5000     5000/18000

B     6000     6000/18000

C     7000     7000/18000

I have created a table and a filter using the above data set, and added a filter for region.

I have added a calculation in table that shows sum(Value)/Sum(Total(Value)), when I applied filter of region that is if I select A in region filter then it also filtered the value of Sum(total(Value)).

How can I ignore Sum(Total(Value)) not to filtered on applying region filter?

[sunny_talwar]

Try this:

Sum(Value)/Sum(Total {<Region = >} Value)

[MindaugasBacius]

Use set analysis:

Sum(Value)/Sum({1}TOTAL Value)

There you go with the attachment.

[sunny_talwar]

Mindaugas‌ -  I think 1 would ignore all the filters and there might be other fields such as product, supplier where you still want your denominator to be filtered on.

[#5]

Thanks Sunny,

Region  Sub-Region   Value     sum(Value)/Sum(Total(Value))

A     zaq     5000     5000/10000

      jhg     3000     3000/10000

     had     2000     2000/10000

B  xcv   6000     6000/12000

     sda     1000  1000/12000  

     asdf     2000     2000/12000

     sdf     3000     3000/12000

C   mnv  7000     7000/8800

     asd     500     500/8800

     sdaf     600     600/8800

     ASD     700     700/8800

What should I do if I have sub-regions for the same data set, I want that if I have applied region filter then it should show Region A and divide the data by Total of region A values?

[sunny_talwar · Accepted solution]

Try this:

Sum(Value)/Sum(Total <Region> {<Region = , Sub-Region = >} Value)

[MindaugasBacius]

Well, I have to agree with you.

Your suggestion is more flexible.

[#8]

Not working.

Region  Sub-Region   Value     sum(Value)/Sum(Total(Value))

A     zaq     5000     5000/10000

      jhg     3000     3000/10000

     had     2000     2000/10000

B  xcv   6000     6000/12000

     sda     1000  1000/12000 

     asdf     2000     2000/12000

     sdf     3000     3000/12000

C   mnv  7000     7000/8800

     asd     500     500/8800

     sdaf     600     600/8800

     ASD     700     700/8800

My output should be after applying filter:

Region  Sub-Region   Value     sum(Value)/Sum(Total(Value))

A     zaq     5000     5000/10000

[#9]

Region  Sub-Region   Value     sum(Value)/Sum(Total(Value))

A     zaq     5000     5000/10000

      jhg     3000     3000/10000

     had     2000     2000/10000

B  xcv   6000     6000/12000

     sda     1000  1000/12000 

     asdf     2000     2000/12000

     sdf     3000     3000/12000

C   mnv  7000     7000/8800

     asd     500     500/8800

     sdaf     600     600/8800

     ASD     700     700/8800

What should I do if I have sub-regions for the same data set, I want that if I have applied region filter then it should show Region A and divide the data by Total of region A values?

[#10]

Region  Sub-Region   Value     sum(Value)/Sum(Total(Value))

A     zaq     5000     5000/10000

      jhg     3000     3000/10000

     had     2000     2000/10000

B  xcv   6000     6000/12000

     sda     1000  1000/12000

     asdf     2000     2000/12000

     sdf     3000     3000/12000

C   mnv  7000     7000/8800

     asd     500     500/8800

     sdaf     600     600/8800

     ASD     700     700/8800

My output should be after applying filter:

Region  Sub-Region   Value     sum(Value)/Sum(Total(Value))

A     zaq     5000     5000/10000