Retain original percentage value after filtering

[DandarahZ]

Hi,

I have a project that is supposed to show room usage percentage as shown below:

In the picture is the values that have been calculated but not have any filters applied to it.

Next, I used 2 list object to filter the display to suit the requirement. However, after applying the filters, the values that are originally displayed changed. The values in the graph above, when filtered, increased. The percentage of the newly filtered graphs add up to 100% of the newly filtered object as shown below:

Is there a way for me to filter the data, while still retaining the original values in the first graph?

Regards

Dan

[FredrikE]

Hi!

In 7.x I think it's hard to solve it, but in 8.3 and 8.4 it might be possible using aggregated tables.

//Fredrik