Problem faced while creating Report

[Anonymous]

Hi,

Could anyone help ,How to get rid of current selection while creating report?

Data in the report changes according to the current selection

but I want  that current selection does not change the data that are  already there in the report.

Thanks

[its_anandrjs · Accepted solution]

Use SET analysis in your charts expression like

Eg:- If you have dimensions Year, Month, Region, Country

In Expression

Sum({< Year=, Month=, Region=, Country= >} Sales)

IF you use dimension with '=' SET analysis expression bypass the selection from the expression.Suggest use the current selection expression with equal sign in the expression then no effect in the chart.

Regards

[nizamsha]

u can nullify the dimension which should not affect ur report

sum({$<year=,month=,quater=,country=,region=,sales=>}Sales)

[PrashantSangle]

Hi,

Try with

1> nullifying  fields

2>select Detached option box from general field.

Regards,

PS

[#5]

Create a Bookmark, and define the report to print with that Bookmark selections. You can do it from the Report Settings --> Selections --> Bookmark