Hello, In the same pivot table you will find an option to create chart at the end. Use it and select line bar. It will work.

Dear Show us the criteria of your target report. a) Did you kept the same BIN formula(in the first report) as a filter in target report and made it is prompted? b) Are you adding any new dimension to the target report which is not in source report?

Please close the threads you opened if it is answered, so that it will be helpful the other users in the forum.

Dear, Why dont you try BI Publisher bursting? Adding Bursting Definitions

Hello, What is the use of joining as such? anyway data doesnt exist at the D1 level.? Provide some sample data

Open the job manager and check.

He will be busy in fixing his issue. Hopefully he will come back and close the thread once he is done with his task ...

Try something like below case when POSITION(',' IN '@{yourVariable}')>0 then 'USD' else yourcurrencycolumn end

something like below case when POSITION(',' IN '@{yourVariable}')>0 then 'USD' else yourcurrencycolumn end Thanks Aj

cant you find(locate) the comma in the variable data and assign USD if you find a comma in the variable value?

why cant you filter it in criteria? Rank(Sum(yourmeasure)) <=100?

sum(case when count(distinct order_id ) between 1 and 10 then 1 else 0 end by cust_id,cust_country) include the cust_id in report and exclude it from results. add a group by clause at the end and see

can you try below formula and let me know. sum(case when count(distinct order_id by cust_id,cust_country) between 1 and 10 then 1 else 0 end) if you are using order quantity, you can use sum(order_quantity). Thanks Aj

Provide the table details with columns?

Condition report

It is always better to have the data at backend. However in this situation , you can achieve it by creating two different reports and creating a condition in section of your dashboard page. Let me know if you need any further help. in the first report values to be filtered by the prompt values and second report without…

As long as you kept a different name for your connection pool and database there should not be any issues. Provide a screenshot of error message your are getting.

in filter fx add those columns (column1+column2+column3+..ColumnN) > 0 as a condition.

let me escape from this ....