Hi All,
I am working on Web I XI R2 and my report has a Cross-tab. This cross-tab has 2 dimension for the drilling purpose. These objects are Quarter and Product.
On my report i am showing data for all the 4 quarters and FULL YEAR TOTAL.
Now, when i drill only on Quarter object assume Q1, The "FULL YEAR TOTAL" still should show sum of values for all the months (from 1 to 12) and for all the products, even if the report is showing data only for Month1 to Month3 because of Quarter filter. This issue i could resolve using NoFilter() function for "FULL YEAR TOTAL".
Issue comes as soon as i drill report on Product dimension.
Assume i drill report on Quarter Q1 and Product P1. In this case "FULL YEAR TOTAL" should show data for only Product P1 but for all the Months (From 1-12). That means, Quarter filter should not affect my "FULL YEAR TOTAL" but Product filter should ....
but as i have applied NoFilter function to calculate "FULL YEAR TOTAL", so its ignoring Product drill filter also and showing data for all the Months and for all the products.
Can any body please provide me solution for the same...If any....
Please let me know if i should provide more information and also if anybody knows that how can i upload an attachment because through attachment i can upload an example to explain the issue more clearly.
Thanks & Regards,
Pooja Wadhwa