excel export will work for title export

I am not sure if we can have a straight line. But we can have a connecting line like the below yellow line or a bar in line bar combo. with an additional measure column with a case statement which compares if the other measure values are equal.

If you have a properly defined time dimension you can use ago function. Otherwise u can achieve it with the timestamp functions sum(case when YOURDATECOLUMN between timestampadd(SQL_TSI_YEAR,-1,timestampadd(SQL_TSI_DAY,-DAYOFMONTH(Date '@{AsOf}{2017-05-05}')+1,Date '@{AsOf}{2017-05-05}')) and…

Can somebody help me to understand why cant a simple group by statement for the issue? The one which i posted above?

what is the result for below formula in answers sum(ColumnA by ColumnB) Column B Column C ColumnA Sum(ColumnA by ColumnB) Dont apply any aggregation rule for third column and hide it. Let us know the results.

Why cant you revert the changes in console itself?

did you roll back your changes? did you check the status of services in em?

only 1 measure value for all levels? as it joins like that

Dear DNk, Post the resolution and make it as answered(correct answer) as u figured it out. It would be helpful for the people who are referring to the forum later. Thanks

If we keep disable_cache_hit=1 , page refresh will force query re run..right?

Amazing reply...lol...loved it

for that we can use a disable_cache_Hit in the advanced tab

Is it a windows installation? If not try disabling firewall and check.

using a javascript in the section will have impact for the whole system and all users. It the requirement is only for one user, it will not work.

Please provide an example , so that people will understand better.

There are several tools , you can use for auto refreshing a webpage (eg: Refresh Monkey or Autorefresh for chrome)

It can be done in BI Publisher , i think.

Dear DNK, Try the below formula, sum("YourAmountColumn"by 'None') - sum("YourAmountColumn") Thanks

How did you fix it?

The logic is to fire an event. Without an event we cannot store value to a variable. From the first page u clicked a value which will be passed to the prompt as it is referring to the same column. Now we need to fetch the value to the presentation variable because we need the value in another subject area/column. So to…