Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qliks,
Currently, my applications show Total of all columns, like below:
Are exist way to exclude one column from that total? Of course, that column should be still present in the table. Column, which I want to exclude is:
Dim Year-Month = 2017-May && Dim Plan Code = FCT
Regards
Jacek.
My bad, you need this
If(SecondaryDimensionality() = 0,
Sum({1}Aggr(If(Above($(vRevenue)) > 0 and Above(Only({1<[Plan Code] = {'ACT', 'FCT'}>}[Plan Code])) = 'ACT', 0, $(vRevenue)), [Year-Month], [Plan Code])),
$(vRevenue))
Thank you Pratyush, but is not what I look. That solution just hide/show total and I want to see all time total, but minus one column.
Regards
Jacek.
Would you be able to share a sample where you are trying to do this? Also, you want the total to not include Fcst where Actual and Fcst are both available?
Hello Sunny,
Yes, I want that total, which you described. Unfortunately, I can't attach that application, because contain many important data for firm. I tried to eeduce data by Preparing examples for Upload - Reduction and Data Scrambling but without success.
Regards
Jacek.
What was the issue you ran into while reducing and scrambling your data?
Hello Sunny, I had yesterday problem with connection. I prepare special app just with the problem.
Please reupload!
Access denied to this QV document!
Yes, I forgot about section access. New upload.
May be this
If(Dimensionality() = 0,
Sum({1}Aggr(If(Above($(vRevenue)) > 0 and Above(Only({1<[Plan Code] = {'ACT', 'FCT'}>}[Plan Code])) = 'ACT', 0, $(vRevenue)), [Year-Month], [Plan Code])),
$(vRevenue))