Mr.Excel,
Am really very happy to take your help/tips on excel.
I have couple of requirements as mentioned below:
1. In powerpivot stacked chart am not able to see grand totals column is being selected automatically. And even am not able to select the series because it is disabled. When i tried to add series manully then then the problem is that chart is not aligned as per slicer selection. Please advise me how can i show grand totals in the chart. (see link below)
http://www.2shared.com/file/I53GmC6c/Example.html
2. Is there any function similar to sumif because i want to add text data into one single cell through vlookup or look because source data & target data files are different
Source file data-
Name Travelled Region
A USA
B APA
C EU
B USA
C APA
B EU
Target file-
Name Region
A =(formula) i.e. USA
B =(formula) i.e. APA/USA/EU
C =(formula) i.e. EU/APA
3. When used counta formula in Measure condition the grand totals is not aligned/filtered to exact breakup but it is showing original grand totals
<TBODY>
</TBODY>
Request you to advise with formulas/way goforward.
Advance thanks
Vamshe
Am really very happy to take your help/tips on excel.
I have couple of requirements as mentioned below:
1. In powerpivot stacked chart am not able to see grand totals column is being selected automatically. And even am not able to select the series because it is disabled. When i tried to add series manully then then the problem is that chart is not aligned as per slicer selection. Please advise me how can i show grand totals in the chart. (see link below)
http://www.2shared.com/file/I53GmC6c/Example.html
2. Is there any function similar to sumif because i want to add text data into one single cell through vlookup or look because source data & target data files are different
Source file data-
Name Travelled Region
A USA
B APA
C EU
B USA
C APA
B EU
Target file-
Name Region
A =(formula) i.e. USA
B =(formula) i.e. APA/USA/EU
C =(formula) i.e. EU/APA
3. When used counta formula in Measure condition the grand totals is not aligned/filtered to exact breakup but it is showing original grand totals
| Name | Permanent | Temporary | Grand Total |
| A | 39 | 250 | 289 |
| B | 18 | 63 | 81 |
| C | 22 | 0 | 77 |
| D | 0 | 35 | 55 |
| E | 26 | 0 | 42 |
| F | 8 | 5 | 13 |
| G | 8 | 3 | 11 |
| H | 8 | 0 | 10 |
| I | 2 | 2 | |
| J | 1 | 1 | |
| K | 0 | 50 | 0 |
| Grand Total | 177 | 479 | 656 |
<TBODY>
</TBODY>
Request you to advise with formulas/way goforward.
Advance thanks
Vamshe
