Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends,
or for a set analysis
this is my measure:-
No filter should work on this
SUM({$<Date_Date={'>=$(=YearStart(Max(Date_Date)))<=$(=YearEnd(Max(Date_Date)))'},Flag={'Visit TYPE REVENUE'}>} SELFPAYER_LC - DISCOUNT + PAYER1_LC)
Regards,
Mohit Dahiya
Message was edited by: Mohit Dahiya
SUM(
{1<
Date_Date={'>=$(=YearStart(Max({1}Date_Date)))<=$(=YearEnd(Max({1}Date_Date)))'},
Flag={'Visit TYPE REVENUE'}
>}
SELFPAYER_LC - DISCOUNT + PAYER1_LC)
I am not sure exactly you question or issue. However if you want to ensure that no filters are applied on top of you Set Analysis then start from the data universe of 1.
I.e.
SUM({1<Date_Date={'>=$(=YearStart(Max(Date_Date)))<=$(=YearEnd(Max(Date_Date)))'},Flag={'Visit TYPE REVENUE'}>} SELFPAYER_LC - DISCOUNT + PAYER1_LC)
Hi Mohit,
I heard that there is an alternate state extension, you can google and use it.
Or you can use Sum({<FieldName1=,FieldName2=>} MeasureName) to exclude the selections in all the objects in a sheet where you want to exclude the selectins.
Regards,
Jagan.
If you want to exclude all selections then try below expression
Sum({1} MeasureName)
Hope this helps you.
Regards,
Jagan.
Not Working. bro when i am selecting any date then it is changing. i want a bar chart on the basis of this measure that will not reflect or changes when any selection will be there in any filter.
NOt working bro
can you provide sample app?
bro its client data. i can show you through team viewer or skype.
Hi Mohit,
It should work. Wherever you want selections to be considered give
Sum(Sales)
Wherever you don't want selections to consider give
Sum({1} Sales) // Ignores all selections
Sum({<Field1=, Field2>} Sales) // Ignores Field1 and Field2 selections
Based on ur requirements use above logics.
Regards,
Jagan.
SUM(
{1<
Date_Date={'>=$(=YearStart(Max({1}Date_Date)))<=$(=YearEnd(Max({1}Date_Date)))'},
Flag={'Visit TYPE REVENUE'}
>}
SELFPAYER_LC - DISCOUNT + PAYER1_LC)